Anyone seen this?
Open a workbook in Excel 2007, and there seems to be nothing open. But the formula bar (and name box) update as you move around this inivisible sheet?
The workbook is open but its window is not visible, but as you arrow around things update – but you can’t see the grid. Switching to this workbook does not display it.
Generally a bit of messing with opening other files and eventually this missing one reappears.
It is not a hidden workbook, seems to be intermittent between users and workbooks. I have mainly seen it when this is the only workbook open.
The workaround I have found so far is to open a new window on the workbook (:2) (if you close it :1 does not appear) then click arrange, this gets both visible, then close 2 and that original partially hidden window appears and is fine.
I did try deleting the .xlb, but then the next person with the same issue did not have one – which shot the ‘corrupt .xlb’ theory out of the water
Anyone else seen this?
anyone got a fix, or a more simple workaround?