Forum Discussion
Opening Excel document from Sharepoint creates a second window
Hi
When I try to open an Excel-file from Sharepoint it opens a second window (pic below). I think it has something to do with when you create macros in your personal workbook then Excel opens your personal workbook when you open a file from Sharepoint. I've tried hiding the personal-file, but I still get two Excel windows when I open files from Sharepoint (like the picture below) I've followed several guides and i've practically tried everything to make it go away but no luck. Deleting the personal-file deletes the macros and I want to avoid that.
Anyone got any ideas? I use Microsoft Office 365 apps for enterprise
Cheers
13 Replies
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.
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!
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!
is it always the same file?
Have you ever checked whether the file is possibly in the XLStart directory or whether a folder should be entered under EXTRAS - OPTIONS - General under "Load all files in this folder when starting"?
Does personl.xls start with you, which may contain code that reloads this file?
Try the following in advance (maybe that's it, never know:):
Window menu - Arrange windows - Vertical - Ok.
You should now see two windows of the same file.
Once with: 1 and once with: 2 at the end.
Close one of the two windows.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
NikolinoDE I'm wondering if your problem was resolved? I'm having the same issue with an Excel file. It just started a couple of weeks ago. I open a file from SharePoint and two copies open. A change that is made in one is reflected immediately in the other. How do I solve this?
Are the files in OneDrive?
... that is more suitable for personal use, in my humble opinion.
Or are your files in SharePoint Online?... is more suitable for a team with several employees.
Operating system?Control when external references (links) are updated
you find.....
Control links to other workbooks
Manually update all or none of the links in a workbook
Manually update only some of the links to other workbooks
Change the source workbook of one external reference without affecting other external references in the destination workbook
Control the startup prompt for updating links
Edit Link options
Frequently Asked Questions
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
