Linked workbooks in Excel
I have created an Excel workbook that is linked to 10 other workbooks in the same Team. They are all saved within the Team's filing structure. When one of the linked books is opened, an error stating 'Links Disabled: Links to external workbooks are not supported and have been disabled.'
I am trying to encourage my workplace to move over to using Teams as our primary file sharing platform, but this is a major issue and will halt that progress.
Paulo Martins commented
I wonder when excel link-links will work on sharepoint?
It is very important for our corporation.
I simply will NOT advocate Teams or Sharepoint for this reason. We live in linked Excel files, and cannot/will not have our links jeopardized by a sharing platform that doesn't anticipate this.
Cody Rush commented
I agree with all you. I eventually gave up, and started using the Sharepoint Lists and setup the Sharepoint Lists Data connector in Excel (Only available if you have an O365 E3 License (Not available in O365 Business Premium). But in my Scenario, I only needed to pull over our master data sheet (Vendors names, Employee ID's etc.). And have our people update the list in Sharepoint. This fixed my problem. But May not fix your's
I just spent a lot of time linking multiple workbooks on our Sharepoint. Works great until you close and reopen the file online. Links are broke. They don't open unless you have both files open in desktop view. Using Excel to link this data together through Sharepoint is now going to be impossible. We will need to find a different solution to pull all this data together. Sucky...
Brad Fisher commented
Agree. Download excel file to work externally. Upload file and formulas are "blown away" and links disabled. Lots of work, down the drain. Very problematic.
Agreed something needs to be done here. When you open a excel file and make changes to data, not only does it have to be opened in Excel for the link to work, but the other excel files that are linked to the updated data (and uploaded into teams/sharepoint) do not automatically update until you open those files in the full version of excel. As such, users are viewing the linked documents in teams but may not be seeing the most recent version.
Fully agree. This is a critical issue in the online version of Excel.
Linking to another workbook (in the same Sharepoint) works in desktop version of Excel, but there are other issues.
Kevin Spaner commented
In our Bureau we track and link budgets in Excel. It is very disappointing Network Excel files cannot be linked to Sharepoint List Excel files which is an obvious use of Sharepoint and unresolved by Microsoft. This issue discourages the growth of our Sharepoint community.