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.
Jillian Rose
shared this idea
26 comments
-
Anonymous
commented
Hi, Is there an ETA on a fix for this?
-
Anonymous
commented
we are in the same boat.. Dear microsoft pls solve this case ASAP
-
Anonymous
commented
VBA also does not seem to function within Teams.
-
Anonymous
commented
Same boat here too, sad to say.
-
Anonymous
commented
We are in the same boat. We have encountered so many limitations with Excel workbooks/sheets stored in Sharepoint/Teams that we had to move back to Google apps/Sheets. The lack of workbook-workbook link functionality in the online system is the biggest issue we have encountered with sharepoint/Teams Excel workbooks though. Workbook linking is a critical requirement for us and it is unfortunate that we cannot utilize the teams/sharepoint environment that our company invested heavily in at this time.
-
Alan R
commented
I have deeply embedded hierarchical file structure on our server with excel workbooks linking together throughout that hierarchy. They are complex in their nature having been crafted over many years. I am so glad that I tested out the migration of these files from the outset before I even considered a migration to Sharepoint and the cloud. The hierarchical linked file functionality that makes desktop excel so useful will not work as migrated into Sharepoint. Possibly you may be able to rewrite them but I don't have the time to reinvent the wheel.
-
Jim
commented
Seriously regretting our company's move from Google to Microsoft. It's already insane that I have to switch between web versions and desktop versions based on what I want to get done. It's ludicrous that you can easily link workbooks "offline" but have absolutely no options for online shared files.
-
FELix
commented
Когда будут работать ссылки на внешние книги?
-
Anonymous
commented
Agreed, this would be absolutely required for simplification on excel managed document and is a greatly required feature.
-
[Deleted User]
commented
Good Day, I'm in the same boat. MS Teams is the answer fro the future, but we need more rapid enhancements, like the link to files and ODBC connections.
-
Zubair Kareem
commented
We need this function urgently, there is no means of using excel on teams with out this...
-
Anonymous
commented
I agree, the functionality must exist in order for my organization to use Teams in the way that best fits our business needs.
-
Nancy Shaw
commented
Absolutely agree this is a critical feature. Having to download to desktop to create links and re-upload to the cloud defeats the purpose of the cloud, creates inefficiencies, and robs Excel of major functionality. Please make this available asap.
-
John Pierce
commented
Absolutely necessary functionality. If I am going to use Teams efficiently need links across Teams, team files and excel. Thanks for posting and I look forward to receiving the functionality.
-
Jamie Riley
commented
Microsoft loves rolling out half-baked solutions. Trying to gain user adoption is near impossible with Teams due to the loss of basic functionality.
-
Abi
commented
If Teams needs to be one place to use Microsoft apps, enabling this feature in Excel online/sharepoint is critical to reduce the need to switch to the Excel software. I use links to different files in sharepoint and need this updating automatically without having to open the files in Excel each time to update.
-
Alban Sestiaa
commented
I agree with all of this. We have the same problem and this is a critical issue (if we want to really use Teams for exemple)
-
Paulo Martins
commented
I wonder when excel link-links will work on sharepoint?
It is very important for our corporation. -
Anonymous
commented
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
