Friday, August 15, 2014

Microsoft Excel opening a blank grey page as well as the document on double-click to open.

I have been dealing with having a blank excel and the document I opened for quite some time.  It only happened when I opened via double click on the file. Because of this, I always have two icons for excel.  Today, I was determined to solve it.   IT IS SOLVED, yippee!

I have Windows 7 and Office 2013.

Ok, here is what I did:
Excel automatically opens any files in the XLSTART folder. I went to C:\Users\(User_Name)\AppData\Roaming\Microsoft\Excel\XLSTART (replace "(User_Name)" with your user name) and deleted the files in this folder. You may want to move those files to some other location (i.e create a backup of those files and delete all files from here).

In my case I had a file in there that was corrupt "Personal.xlsb".  After deleting this file, the issue was resolved. 

If you did not find any files in that folder, verify this is the correct path for your folder.
1. Open excel
2. Click File
3. Click Options
4. Click the Advanced menu
5. Locate the General section.

Under Advanced/General, there is a box "At startup, open all files in: