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.
THANK YOU!
ReplyDeleteGreat.. was of big help.. Thank you very much..
ReplyDeleteThank you! Big help!
ReplyDeleteI 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?
ReplyDeleteyes, what is missing?
ReplyDeletethat field was blank - setting it to a folder location did not solve the problem.
ReplyDeleteDeleting the files in that folder fixed it for me. Thanks!
ReplyDeletewhat should be there in the field???
ReplyDeleteYou are the man! Nothing else I found on this topic was helping me to address this problem.
ReplyDeleteFor 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!