Links between spreadsheets in Excel Online
It would be nice for links between spreadsheets on my One Drive to work.
Thank you for your continued feedback and responses. I am excited to let you know that the work for External Links for Excel on the web has started.
Microsoft Excel Team
Help this we need this function!
Elizabeth Peggs commented
Really urgent that this gets resolved. We are now using OneDrive as primary resource for file management and back up. The spreadsheets we manage are complex and a high value work product yet we can not have them on OneDrive as it represents 100's++ of hours of work for formula management in this environment. HELP!!
I'm still getting error messages that links to external workbooks aren't supported, it appears that you started working on this last year, what is the status?
While this functionality is still not available for Excel Online, I have found a workaround if you have excel for desktop.
This works for Mac or PC.
Follow the instructions in the support link recently posted (Paste Link).
This at least solves the linking function. You cannot refresh the documents in excel online, but you can open the documents in the desktop version to see them refresh, which refreshes the online version.
Not perfect, but it at least comes close solving the pc/mac data connection compatibility issue.
My org is hybrid, half on mac, half on pc, so this has been something I've been needing for a long while. It's still really clunky, but it's progress...
I saw it yesterday with a Microsoft Engineer. It seems youi have to wait for almost 3 weeks
How come this How To is uploaded but not available yet? Really frustrating!
Albert H commented
Google sheets can do this for free
People, PLEASE stop referring to this as a "feature"!! This is not a feature. This is a BASIC business requirement; that was not considered in error.
What we are asking for is for MS to FIX their error. Mich different than a "feature request"
I confirm the post below, the integration is rolling out. The documentation is up to date on the Microsoft web site and is deployed on Microsoft environnement. I saw it this morning with our engineer in customer change manangement.
It's a very good news. I'm in a hurry to see it and to try it !
Actually insane how our business was recommended to move from Google Docs to Office 365 when basic collaborative tools like this cost the business so much time when we don't have them.
So according to various articles this is rolling out,
Has been for nearly a month. Even on their product how to page now.
Why do we all not see it?
dear Microsoft team
You have our money
Your have our loyalty, comittment, and admiration for all that Excel can do
And you have us begging for a solution to this problem
The courtesy of a reply would be appreciated
Ditto!! Microsoft fix this!
Would love an update on this - It is exhausting that I can do it all on my desktop but once transferred into onedrive all of my links are disabled, undoing all of my work.
GOOGLE SPREADSHEET RULES!! My management urges us to work with Excel spreadsheet. But because of this omission my team is happy to use Google Spreadsheet from 2014. And you know what, every few month, Google Spreadsheet gets new functions. It gets better and better. :-)
This feature is critical for my organization. whats really sad is that I keep seeing the excel team unveiling new features on there twitter feed yet this is the #1 most requested excel online feature.
Nick Doy commented
Honestly, power query is available offline in excel, its available online for the power platform through Dataflows, why is it not compatible in excel online? This should be a no brainer as it all started with excel yet it is the last online platform to get support. MS please sort this out ASAP.
I'm getting so much spam for this in my inbox from notifications. Can gladly state this is the only spam I'm happy to receive.
This thread is blowing up and I am glad. PLEAAAAASS fix this.
Carlos Junges commented
The feature should be available anytime between 2021 and 2025 please hold on