Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm having an issue with one of my daily used Excel sheet. When ever I open the Excel sheet I get a blank page. I mean not even the rows or columns are showing.

I've checked the file and its size is 2.09 MB so the file is holding data. I've tried opening it in different versions of Excel on different computers. But they all have given me the same result.

Anyone know of a way I may be able to recover the data that seems to be stuck in the sheet?

share|improve this question
up vote 0 down vote accepted

It's possible that all cells are hidden. It's surprisingly hard to unhide everything after this happens; one quick way is to use Visibility | Unhide (I tested this in Excel 2010 only), or a small macro which should work in most versions.
Steps for the macro solution:

  1. Press Alt-F11 to get the VBA editor to appear
  2. Double-click on ThisWorkbook on the left
  3. Paste in the below code and press F5 to run it


Sub UnhideAllColumnsRows()
    Cells.EntireColumn.Hidden = False
    Cells.EntireRow.Hidden = False
End Sub

Steps for the menu solution:

  1. Press Ctrl-A to select all
  2. In the Home tab, in the Cells section, select Format
  3. Select Visibility, then Hide or Unhide
  4. Select Unhide Rows

Repeat steps 3-4 for Unhide Columns

share|improve this answer
Hi Geoff, I tried this and I get the following Run-time error '1004': Application-defined or object-defined error when I execute the above script. I was not able to try the second solution because when I open the spreadsheet I see nothing at all and all tools in the Home/Insert/Page Layout are greyed out. Would you have any other ideas or options? – Nick M. Apr 26 '12 at 21:02
@NickM. - I tried to simulate what your situation might be by creating a new spreadsheet, doing ctrl-a, then hiding all (ctrl-8, ctrl-9). If you do that in a new spreadsheet, does it look the same as your problem spreadsheet? – Geoff Apr 26 '12 at 21:06
this did give the same look and feel. In office 2010, going to View tab there was an unhide button. (I believe this is what your ment in your first post) which fixed the issue. In office 2003 this option is under the "windows->unhide" selection. Thank you very much for your time and help! – Nick M. Apr 27 '12 at 12:37
@NickM. - Glad you got it working – Geoff Apr 27 '12 at 13:15

This just happened to me and I tried everything! After reading similar posts online, I started clicking everything in the Window section on the View tab. When I clicked on New Window, my spreadsheet appeared!

share|improve this answer

We had a similar issue today- opened the workbook and nothing showed, no Save options in File.

Fixed it by importing the sheet into Google Sheets and then downloading the working file.

share|improve this answer

protected by Community Dec 5 '15 at 14:12

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.