Forum Discussion

dblemker's avatar
dblemker
Copper Contributor
Feb 12, 2022

Sharepoint differences in opening Excel files

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 quick...
SharePoint Online
jm_herard's avatar
jm_herard
Copper Contributor
Feb 13, 2022
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.
  • dblemker's avatar
    dblemker
    Copper Contributor
    Feb 13, 2022

    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.

    • jm_herard's avatar
      jm_herard
      Copper Contributor
      Feb 13, 2022
      Can you join a screenshot showing files Porperties from SharePoint?
      • DhirenMehtaMSFT's avatar
        DhirenMehtaMSFT
        Icon for Microsoft rankMicrosoft
        Feb 13, 2022

        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"

         

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

Resources