Restoring missing Microsoft Excel workbook windows

I just had a rather strange problem with Microsoft Excel 2010. When opening the workbook nothing appeared on the screen:

An open Excel 2010 document that appears to have no visible window

Evidently something had loaded since the formula bar contained data from the worksheet, and pressing the arrow keys let me navigate around the cells. Dragging the file into Wordpad allowed me to see the data, which at least meant it wasn’t something like a corrupt file.

The window hadn't been hidden...

At first I thought maybe the window had somehow been hidden, but from the image above you can see the option to unhide the Excel window is greyed out. Figuring the window was probably somewhere I clicked the Arrange All button

Microsoft Excel 2010 Arrange Windows dialog box

After clicking OK the window containing my worksheets appeared on the screen with all the data intact

Restored Excel file, visible on the screen again

It was as if somehow the window containing my Excel workbook had somehow been moved off the visible portion of the screen (but still within the MDI frame of Excel itself), either due to using a computer with a higher screen resolution or because of a random bug. It’s not possible to push the window off the screen maually, a tiny corner remains.

So if you one day open a Microsoft Excel worksheet or workbook and discover that your window is missing, or you have a hidden Excel workbook that isn’t really hidden, try telling Excel to tile its windows to see if it comes back.

About James

If this were the 80s I'd be sat in front of a C64 or Speccy, or taking VCRs apart.