Sharepoint differences in opening Excel files

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3157542%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ESharepoint%20differences%20in%20opening%20Excel%20files%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3157542%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20have%20an%20unusual%20issue%20and%20I'm%20not%20sure%20if%20it's%20a%20teams%2C%20sharepoint%20or%20Excel%20online%20issue.%20On%20our%20teams%20site%2C%20we%20have%20a%20sharepoint%20page%20with%20quicklinks.%20When%20we%20open%20Excel%20files%20on%20some%20of%20the%20quicklinks%2C%20it%20opens%20the%20file%20within%20the%20teams%20structure%20(taking%20over%20the%20entire%20teams%20screen%20with%20the%20exception%20of%20the%20far%20left%20icon%20bar%20and%20top%20menu).%20When%20this%20happens%20the%20user%20has%20an%20option%20to%20%22close%22%20the%20excel%20document%20easily%20with%20a%20button%20that%20says%20close%20on%20the%20right%20hand%20side.%20However%2C%20we%20also%20have%20another%20set%20of%20quick%20links%20where%20the%20excel%20file%20opens%20only%20within%20the%20sharepoint%20page%20section%20and%20doesn't%20have%20a%20close%20button%20but%20only%20a%20%22catch%20up%22%20button%20on%20the%20right%20hand%20side.%20I've%20tried%20to%20see%20if%20there%20are%20any%20setting%20differences%20and%20all%20the%20pages%20seem%20to%20be%20linked%20the%20same%20way%20with%20the%20same%20settings.%20I'm%20not%20sure%20what%20we%20are%20missing%20that%20is%20causing%20this%20difference.%20It%20makes%20it%20almost%20impossible%20to%20close%20the%20file%20without%20%22reloading%20the%20window%22%20and%20returning%20to%20the%20sharepoint%20page.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20suggestions%2C%20I%20feel%20like%20I've%20exhausted%20every%20search%20and%20option%20for%20this.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3157542%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3157542%22%20slang%3D%22en-US%22%3ESharepoint%20differences%20in%20opening%20Excel%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3157542%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20unusual%20issue%20and%20I'm%20not%20sure%20if%20it's%20a%20teams%2C%20sharepoint%20or%20Excel%20online%20issue.%20On%20our%20teams%20site%2C%20we%20have%20a%20sharepoint%20page%20with%20quicklinks.%20When%20we%20open%20Excel%20files%20on%20some%20of%20the%20quicklinks%2C%20it%20opens%20the%20file%20within%20the%20teams%20structure%20(taking%20over%20the%20entire%20teams%20screen%20with%20the%20exception%20of%20the%20far%20left%20icon%20bar%20and%20top%20menu).%20When%20this%20happens%20the%20user%20has%20an%20option%20to%20%22close%22%20the%20excel%20document%20easily%20with%20a%20button%20that%20says%20close%20on%20the%20right%20hand%20side.%20However%2C%20we%20also%20have%20another%20set%20of%20quick%20links%20where%20the%20excel%20file%20opens%20only%20within%20the%20sharepoint%20page%20section%20and%20doesn't%20have%20a%20close%20button%20but%20only%20a%20%22catch%20up%22%20button%20on%20the%20right%20hand%20side.%20I've%20tried%20to%20see%20if%20there%20are%20any%20setting%20differences%20and%20all%20the%20pages%20seem%20to%20be%20linked%20the%20same%20way%20with%20the%20same%20settings.%20I'm%20not%20sure%20what%20we%20are%20missing%20that%20is%20causing%20this%20difference.%20It%20makes%20it%20almost%20impossible%20to%20close%20the%20file%20without%20%22reloading%20the%20window%22%20and%20returning%20to%20the%20sharepoint%20page.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20suggestions%2C%20I%20feel%20like%20I've%20exhausted%20every%20search%20and%20option%20for%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3157542%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have an unusual issue and I'm not sure if it's a teams, sharepoint or Excel online issue. On our teams site, we have a sharepoint page with quicklinks. When we open Excel files on some of the quicklinks, it opens the file within the teams structure (taking over the entire teams screen with the exception of the far left icon bar and top menu). When this happens the user has an option to "close" the excel document easily with a button that says close on the right hand side. However, we also have another set of quick links where the excel file opens only within the sharepoint page section and doesn't have a close button but only a "catch up" button on the right hand side. I've tried to see if there are any setting differences and all the pages seem to be linked the same way with the same settings. I'm not sure what we are missing that is causing this difference. It makes it almost impossible to close the file without "reloading the window" and returning to the sharepoint page.

 

Thanks for any suggestions, I feel like I've exhausted every search and option for this.

10 Replies
The difference does not comes from the file itself but the way of opening it.
From Teams, you are opening your file in Excel Online (which shows this close button).
From SharePoint, user will probably have to use the arrows located in his/her web browser.

@jm_herard although I appreciate your reply, it doesn't answer my question. Both files are being opened from the same location (inside Teams on a Sharepoint page from a quicklink). So it isn't about the way of opening it. The files are all excel files opened from a Sharepoint page quick link in teams and they behave differently.

Can you join a screenshot showing files Porperties from SharePoint?

@dblemker  I did some testing on my lab tenant and I have partially noticed the same behavior that you have described. However, few things to note here.
1.  In my case, when I am using QuickLinks web part on the SharePoint page, All the Excel/ Word/PowerPoint files are only showing Catch up button and NOT the Close button. This is because when you use QuickLinks web part, and click on the Link on the page (from the Teams client), it's loading the Link as a whole page in the Teams client. (This is the same behavior you will see when you will click on the Link from the SPO site in the browser directly). Also, you will notice in this scenario that the URL of the Page doesn't change (you can use Fiddler or web version of Teams in the browser to notice this). This means that when you are using QuickLinks web part links in the SharePoint page and when you are opening the SharePoint page from Teams client, Team client is simply opening the link as a new page (like how you would see in the browser).
2. However, When I have Document Library web part on the same SharePoint page and when I tried to open the Excel files form the Library web part in Teams client, I can see the Close button and also, the Excel file taking over entire Teams client real estate (as you have mentioned). This is because when you are opening the file from Document Library web part, Teams client is using DOCX/XLSX Viewer Web/App Part Functionality to display the file and this Web/App part seems to have Close button in it. If you open the teams team in Browser and click on the Excel file from Document Library web part on the SharePoint Page tab, you will see the URL pointing to something like this. https://teams.microsoft.com/_#/xlsx/viewer/teams and also look at the browser tab title changing with something like "XLSX File Viewer | Microsoft Teams"

DhirenMehta_0-1644793206747.png

 

- So from what I am seeing based on my research and testing, the behavior you are seeing is currently by design. However, if you are seeing these two different behaviors using the QuickLinks web part itself, then can you please provide detailed repro steps and some screenshot to better understand the scenario?

@Dhiren Mehta Thank you for this. I thought you were on to something... but alas I don't think so. I'm going to try to share as much as I can about the files without violating our company policy with information sharing. 

 

The Sharepoint page loading within teams as our "Main Menu" of sorts is made up of multiple web parts with quick links. I used the browser version of teams to get the links for you as you suggested. One section of the quick links opens an excel document as this: https://teams.microsoft.com/_#/xlsm/viewer/teams

 

The other part opens excel files as this: https://teams.microsoft.com/_#/tab::1a097827-23d1-4415-b11f-fca99483ccb4/General? (within continuing thread ID information that I can't paste without it renaming it).

 

The weird thing is, all files were added the same way: Add Link>Site or Add Link>From a Link. Both options respond the same way. But for some reason, the few files react differently and come up as the xlsm viewer. I don't know how to force it to load it that way. None of my elements are document web parts (that I know of). Everything is set up as quick links.

Thanks @dblemker . Based on your response, I still feel that the First excel document that's opening up is Not Quick Link but without actually looking at it with screenshare, I don't have any other ideas to offer. Only other thing I can think of is you can edit the page in SPO site in browser, Delete the "non-working" quick link and re-add it to see if you are seeing any difference in behavior.  Be sure to publish the page after the changes are done.

Can you open up a Support ticket with our Teams team so that Microsoft Support team can work on this with you?

@Dhiren Mehta Thanks. I will see if I'm able to open a ticket. I created the sharepoint page and each section. They are all quicklinks added the same way. The two attachments here show each file (as quicklinks) all adding the same. One loads in the viewer, one loads the other way. I'm at a loss. 

I think I might have it. The files that open full screen are xlsm files and the others are xlsx files. Let's see if that fixes it.
Interesting. I just tested it and yup it is that. xlsm type files opens up with Viewer in Teams but XLSX files open in the SharePoint page. In my initial testing, I did test Quick links using XLSX and XLS extension types and saw the same results, so didn't think of asking the distinction but glad you caught it.
Known issues: .xlsm files do lose their co-authoring features in SharePoint.