Forum Discussion
Opening Excel document from Sharepoint creates a second window
Same problem. As soon as my spreadsheet is moved from my local computer to either SharePoint or my personal OneDrive, opening it in Excel 365 does exactly what's described. I do have macros but they're in the Personal Macro Workbook, not any of the sheets I open. Closing the empty Excel window closes the workbook I want. My workaround (not solution) is:
- In either Excel window, on the View tab's Window group, click Hide. This hides both windows but leaves Excel running. (The fact this works from either window also proves there's an association between the two, just like closing either window closes both.)
 - From the View tab's Window group, click Unhide and select your workbook. The unhides your workbook in the running window and doesn't re-open the empty window.
 
I have a little theory this might be related to hidden(?) temp files on the local machine that are necessary due to the source being SharePoint/OneDrive. It never happens with local files. It always happens with SharePoint/OneDrive files. It doesn't matter whose SharePoint I'm connected to, mine, a client's, etc.
- AWCombsMay 07, 2021Copper Contributor
NemanSyedOfficial The easy way to fix this, or at least it worked for me.
- Select the blank window
 - Click on 'Save As'
 - Copy the address to an explorer window (note the name of the file it is wanting to save as)
 - Close the empty excel window
 - delete the file in the XLSTART explorer window that was causing the blank window.
 
Good luck!
- NemanSyedOfficialMay 11, 2021Copper Contributor
AWCombs thank you! As it turns out, it's not something I can delete - it's my Personal Macro Workbook!!
This isn't what I expected. I was expecting a temp file or some other form of detritus. I believe this must be some sort of bug that comes out of old tech + new tech. It's quite annoying, but I may have to live with it until someone at Microsoft finds it equally annoying enough to fix. Much appreciated!
- AWCombsMay 11, 2021Copper Contributor
NemanSyedOfficial If you don't need the macros with every excel workbook, you could probably cut it and paste to a personal folder elsewhere and manually open it when you need those macros.
I hope you find a solution.
Tony