Opening Excel document from Sharepoint creates a second window

%3CLINGO-SUB%20id%3D%22lingo-sub-1961976%22%20slang%3D%22en-US%22%3EOpening%20Excel%20document%20from%20Sharepoint%20creates%20a%20second%20window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1961976%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20I%20try%20to%20open%20an%20Excel-file%20from%20Sharepoint%20it%20opens%20a%20second%20window%20(pic%20below).%20I%20think%20it%20has%20something%20to%20do%20with%20when%20you%20create%20macros%20in%20your%20personal%20workbook%20then%20Excel%20opens%20your%20personal%20workbook%20when%20you%20open%20a%20file%20from%20Sharepoint.%20I've%20tried%20hiding%20the%20personal-file%2C%20but%20I%20still%20get%20two%20Excel%20windows%20when%20I%20open%20files%20from%20Sharepoint%20(like%20the%20picture%20below)%20I've%20followed%20several%20guides%20and%20i've%20practically%20tried%20everything%20to%20make%20it%20go%20away%20but%20no%20luck.%20Deleting%20the%20personal-file%20deletes%20the%20macros%20and%20I%20want%20to%20avoid%20that.%3CBR%20%2F%3E%3CBR%20%2F%3EAnyone%20got%20any%20ideas%3F%20I%20use%20Microsoft%20Office%20365%20apps%20for%20enterprise%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22opening%20file%20from%20sharepoint.jpg%22%20style%3D%22width%3A%20433px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238214iDE66D5CB0641AC73%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22opening%20file%20from%20sharepoint.jpg%22%20alt%3D%22opening%20file%20from%20sharepoint.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1961976%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1962512%22%20slang%3D%22de-DE%22%3ESubject%3A%20Opening%20Excel%20document%20from%20Sharepoint%20creates%20a%20second%20window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1962512%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893189%22%20target%3D%22_blank%22%3E%40r0uladen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eis%20it%20always%20the%20same%20file%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHave%20you%20ever%20checked%20whether%20the%20file%20is%20possibly%20in%20the%20XLStart%20directory%20or%20whether%20a%20folder%20should%20be%20entered%20under%20EXTRAS%20-%20OPTIONS%20-%20GENERAL%20under%20%22Load%20all%20files%20in%20this%20folder%20when%20starting%22%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EDoes%20personl.xls%20start%20with%20you%2C%20which%20may%20contain%20code%20that%20reloads%20this%20file%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%3CSTRONG%3ETry%3C%2FSTRONG%3E%20the%20following%20in%20advance%20(maybe%20that's%20it%2C%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%20C1N51c%22%3Enever%20know%3C%2FSPAN%3E%3A)%3A%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWindow%20menu%20-%20Arrange%20windows%20-%20Vertical%20-%20Ok.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20should%20now%20see%20two%20windows%20of%20the%20same%20file.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOnce%20with%3A%201%20and%20once%20with%3A%202%20at%20the%20end.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EClose%20one%20of%20the%20two%20windows.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2257373%22%20slang%3D%22en-US%22%3EBetreff%3A%20Opening%20Excel%20document%20from%20Sharepoint%20creates%20a%20second%20window%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2257373%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3BI'm%20wondering%20if%20your%20problem%20was%20resolved%3F%26nbsp%3B%20I'm%20having%20the%20same%20issue%20with%20an%20Excel%20file.%26nbsp%3B%20It%20just%20started%20a%20couple%20of%20weeks%20ago.%26nbsp%3B%20I%20open%20a%20file%20from%20SharePoint%20and%20two%20copies%20open.%26nbsp%3B%20A%20change%20that%20is%20made%20in%20one%20is%20reflected%20immediately%20in%20the%20other.%26nbsp%3B%20How%20do%20I%20solve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

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



opening file from sharepoint.jpg

9 Replies

@r0uladen 

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)

@Nikolino 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?

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.

@r0uladen 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?

@62Fender 

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

 

 

@Nikolino

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.

@r0uladen 

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:

  1. 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.)
  2. 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.

SNAG-20210413-131953-0160.png

 

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!