Share via

Unable to add an excel sheet stored in another sharepoint as a tab

Anonymous
2024-03-13T14:49:25+00:00

Good Morning All,

I have an odd one, haven't been able to figure out a solution or find anyone else who's facing the same issue in our organization. We're on the "new" teams and use onedrive along with sharepoint for our project documentation. I created a new team for our project and am trying to add a tab that shows an existing excel spreadsheet from another sharepoint site that is for the same project. (Why Microsoft won't let you point the "files" section to an existing site is beyond me, but I digress) When I hit the + and pick Excel, I get the dialogue box below.

If I pick "more places" it just asks me for a link. If I paste in the link from the sharepoint site it says it's an invalid link. As far as I can tell my permissions and access to those sites are the same as everyone else on the project. I asked another guy on the team to try it and he gets this as his first window after selecting "excel"

The first quick access item he sees is the site I'm trying to access, which incidentally shows up just fine in my onedrive tab in teams.

I've tried logging out of everything and back in, reinstalling teams, reconnecting onedrive, nothing has worked so far. Fairly frustrated, since it'd be a huge help to be able to create tabs of existing documents from that sharepoint site. Any help would be much appreciated.

Microsoft Teams | Microsoft Teams for business | Files | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-03-14T12:51:11+00:00

    Hi Sophia,

    Thanks for the suggestions. Unfortunately after clearing the cache, trying the web version, and reinstalling teams it's still showing me the wrong UI. I'll see if I can get in touch with our Office 365 Admin to open a ticket.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-03-14T05:08:14+00:00

    Dear Kris Oftedahl,

    Good day!!

    Apologies for the inconvenience caused and please don’t worry, let’s work together on your concern and move towards a resolution path.

    I understand your concern and, in my opinion, the behavior you are facing is not an expected behavior because Excel app or Word app or PowerPoint app in the tab of Teams channel tab will show the My Files of your OneDrive and SharePoint Online sites having access.

    However, you are having the different UI when accessing the Office apps in the tab of Microsoft Teams. In this situation, I would like to confirm whether you are having the same behavior in the Microsoft Teams browser:

    Open Google Chrome browser or any other browser> Access https://portal.office.com > Enter Office 365 account details> Click on the 9 dots at the top left> Click on the Teams> Go to the Teams tab> Go to the Channel> Click on + > Click on Excel> See whether you are prompted similar to the screenshot as the above.

    If yes, then the problem is with the Teams application at your end and I would like to suggest you clear the Microsoft Teams app cache and see the outcome: Clear Teams cache - Microsoft Teams | Microsoft Learn

    If clearing the Cache doesn’t have any success, we are sorry and request you to uninstall the Microsoft Teams app: Uninstall Microsoft Teams - Microsoft Support

    After uninstalling restart your Microsoft Teams app and re-install the Microsoft Teams app to check the outcome: Download Microsoft Teams Desktop and Mobile Apps | Microsoft Teams (Download Teams for work or school)

    If still the same issue, then I believe the problem should be further investigated by related development team via collecting Fiddler logs because there is no any related service incident reported at the Microsoft Service Health dashboard.

    I do feel regret for not resolving the problem and redirecting you to the related development team but the fix to your concern can be find out through the Fiddler logs and suggest you raise a support ticket from the Office 365 admin center, where the related team will investigate the problem further by collecting the Fiddler logs.

    Reference: Get support - Microsoft 365 admin | Microsoft Learn

    Note: To create a support ticket, you need to have admin privileges and if you aren’t admin of your Office 365 organization, please contact the admin of creating a new ticket.

    As a workaround till the problem is resolved, please follow the below steps:

    Go to the location where the file is stored> Right-click on the Excel file> Copy Link> Use People in organization or people with existing access> Go to the Teams Channel> Click on +> Website> Give a tab name> Paste the copied link at URL section> Save.

    Appreciate your patience and understanding. Have a great day!!

    Best Regards,

    Sophia

    Was this answer helpful?

    0 comments