Excel: Open file, blank window – Change Resolution

A user will occasionally call up saying that an Excel file won’t open.  In this particular instance (through some interrogating), what happens is that the user opens the file, Excel opens, but it looks like the file itself did not open; the background of Excel is visible, along with the ribbon, but you don’t see any cell at all.  You can close Excel and re-open as much as you want, but you’ll get the same results.

What you need to do is change the resolution and the window will appear within Excel, but the window is not maximized.  Once the resolution is changed, maximize the window within Excel and you can change the resolution back.

My theory on this is that someone else was working on the file with the window inside Excel not maximized, and they have a different resolution.  When the person with said issue opens the file, the window is in “Restored” mode, but off the screen.  Changing the resolution (for some reason) seems to move the window to a visible portion of the Excel instance.

This was a problem that was extremely bothersome and really hard to research.  How I found the solution was because one user had a terribly low resolution that was bugging the crap out of me, so I minimized Excel, changed the resolution, and then switched back to Excel.  Low and behold, there was the file’s contents.

Details:

  • Windows 7 (so far, I’ve only seen this on 32-bit)
  • Excel 2007 (I don’t ever recall this with 2003 or 2002/XP)
Advertisements

About Mike S.
I work on computers and pretty much anything that plugs in. I'm also an avid gamer, and huge Bruins fan. Yay me....

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: