Forum Discussion
Opening Excel document from Sharepoint creates a second window
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
- NikolinoDE
The problem magically solved itself yesterday. The file was stored in SharePoint. I opened it yesterday, closed the one copy and started editing. After saving and reopening, it only opened the one copy. No idea what that was all about.- If it works, it works ... Murphy's Law 🙂
I hope you continue to have fun with Excel.
- So you have to ask roulades if he could solve his problem with it. Or you can carry out the same steps yourself.
Or I misunderstood everything again for once again through the translation :))
Apologize in advance ... if so.