Connect two Excel spreadsheets in TEAMS

New Contributor

Dear Community, 

 

A month ago I decided to save my huge Excel file in Teams and make it available to my team. So now two dozen of colleagues can insert their entries independently and in parallel.

 

This is very helpful because I can also see who changed what and when.

 

Now I have the problem that certain colleagues have to make double entries (same content in my and another table).

 

Therefore, I would like to connect two Excel files, which must remain separate. To do this, I have copied a cell and pasted it into the other table via "Link Paste".

 

The tables are stored in the same folder on Sharepoint. However, I get an error message, that the link was blocked. Has anyone an idea how to solve this issue? 

 

The link looks like follow: 

='https://xxxx.sharepoint.com/sites/Project/Shared Documents/[Excelfilename.xlsx]TabName'!$H$149

 

The following error message appears:

"Connection blocked
External connections to other workbooks are not allowed."

 

1 Reply

Hi @IDontThinkSoTIM  This sounds to me like an Excel question, not a Teams question.  I'm moving your post to the Excel community discussion forum.