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:

9 comments:

  1. Great.. was of big help.. Thank you very much..

    ReplyDelete
  2. I don't know if it's just me, but I can't see what you do after: "Under Advanced/General, there is a box "At startup, open all files in:" What is missing?

    ReplyDelete
  3. that field was blank - setting it to a folder location did not solve the problem.

    ReplyDelete
  4. Deleting the files in that folder fixed it for me. Thanks!

    ReplyDelete
  5. what should be there in the field???

    ReplyDelete
  6. You are the man! Nothing else I found on this topic was helping me to address this problem.

    For me, the file was being placed one directory above the XLSTART folder (C:\Users\(User_Name)\AppData\Roaming\Microsoft\Excel\). And the path wasn't showing up in my Excel options, it was blank (just like the one in your screenshot). I just happened to notice there was an extra file hanging out in that location by the name of 'Excel15.xlb' that had been created around the same time I opened my Excel file. So I moved it and now there isn't an extra blank, grey Excel file opening up every time I open an Excel file. I'm using Office 365 over Windows 10.

    Thank you!

    ReplyDelete