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
Come on microsoft. This is a crucial function to have. People wanted this for 5 years now.. Can we at least have an update ? Roadmap ? Anything? It works perfect in google sheets....
That's great news, but are you able to share a timeframe?
Will this be the equivalent of google sheets "Importrange" where you can feed live data between cloud workbooks? It's the key feature missing from excel that's the reason I have to run parallel systems to google sheets.
Any timeframe for this feature to be available? We really need it.
Hernán López commented
Hello, we wait for many months. Maybe the companies use a VPN for files. But we want to use it since last year, maybe if this would work, all the companies will use office 365. Please we urge an answer.
I was asked to provide this feature today and was shocked to discover it's not available. Users using Excel spreadsheets in SharePoint need to be able to link cells in one spreadsheet to another.
Has this been released?
I need to add an additional comment for all the users that want this to work not only in desktop, but also in Online version. Linking to External Sources will be absolutely useless for online if pivot tables, etc. is not also made possible. Well at least for me. And I presume most businesses.
MS please make sure you not only make it possible for online version, but make the possibility worthwhile by enabling all the other features associated to pulling data!
Are there any updates on this functionality? This is a real problem with us adopting the 365 platform. We rely on "importrange" in so many areas. We need a microsoft solution here. Please let us know the updated info on this issue.
Thanks a lot for this information Vinay. I read the release notes and I see only fix on the external links in Excel Desktop. What we want and it's very important for us it's the ability to work with EXCEL ONLINE and the EXTERNAL LINKS between spreadsheets.
We have 10000 users working with E1 licences :-( you see what's it means for us when they open an excel worksheet with external links....
They hate Microsoft for this lack of feature !
Vinay Ayinapurapu commented
I just came from our internal MSFT team that this is already in place for the office pro-plus version build 12527. Here is the link about the Pro-plus updates
https://docs.microsoft.com/en-us/officeupdates/update-history-office365-proplus-by-date. The release notes says issue with update of the external links are fixed. Haven't tested this yet since this release is still not availalble to us.
Stefano Patriarchi commented
Came on Guys! :)
This is great news David!
Business is migrating to One Drive and as one of the first to move hit this issue on day one. Work around is just way too clunky need to get a proper fix ASAP.
My team need this functionality desperately, the business is moving away from Google Drive but the ability to link the sheets is mission critical. Get on this ASAP please!
Any feedback MS?
Jay Merculief-Barker commented
Need this funcationality, like yesterday!!! Can't believe we had to leave Google sheets to go to o365 and losing so many functions!
Working from Home 24/7 is really showing the deficits with O365 and One Drive. Wish I was the decision maker here 'cause we'd be moving to Google.
If you want to link online worksheets, switch to Google Sheets
Really need this functionality. almost 6 months since you started work. Please give your community of customers an update!