Unable to open Excel file via integrated SharePoint library in TEAMS

Fulton, Tim 1 Reputation point
2021-01-27T21:45:09.957+00:00

We have added a SharePoint Online document library to a Microsoft TEAM. When viewing a Office file directly in SPO, we can open and create new Office documents successfully.

However...

When we attempt to try to open the same Office document via the TEAMS/SharePoint integrated document library, we receive an "Unknown Error".
When we attempt to create a +New Office document in the TEAMS/SharePoint integrated document library, nothing happens.

Why is this happening and how do I correct?

Microsoft Teams | Microsoft Teams for business | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. JimmyYang-MSFT 58,741 Reputation points Moderator
    2021-01-28T09:47:12.963+00:00

    Hi @Fulton, Tim ,

    Did you create a new SharePoint document library before creating Teams?

    I did a test in my environment and it looks normal in Teams client.

    1.Add document library in Teams site clicking “Add a tab”, then select “Document Library”

    61400-32.png

    2.Copy the document library link and paste it to “Use a sharepoint link”.

    61462-33.png

    61444-34.png
    3.We can create a new excel file and open the file normally in it.

    61463-35.png

    If I misunderstand your requirements, please figure it out. Thanks for your understanding!


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Fulton, Tim 1 Reputation point
    2021-02-10T15:58:11.073+00:00

    While your method works, it requires the conversion of our older SharePoint libraries, which we're not going to undertake as this time. What I have discovered is SharePoint offers three integrations with TEAMS.

    1 - Native integration using the Teams "Files" feature - this creates a new SPO library from Teams

    2 - Teams integration APP - SharePoint - allows you to view the content of the SharePoint site but you can not open files (the problem I described)

    3 - Teams integration APP - Document Library - allows you to view the content of SharePoint 2013 libraries AND open files - our solution

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.