Links between spreadsheets in Excel Online
It would be nice for links between spreadsheets on my One Drive to work.
We have started rolling out support for workbook links to Excel for the Web. You’ll know you have it if you see the “Workbook links” button on your Data tab. Most of you should have it by now.
To create new workbook links, copy from the source workbook and right click/paste links in the destination workbook.
You can read more here:
- Joe [Excel]
Please include the features of linking 2 excel as this is very important features and if the users have to use cloud version it helps a lot...What all features available on desktop should be made available on cloud also.
Why this function is so ********? I linked a table from another sheet (2000x20) and file size changed from 6 to 60 Mb!!!
Excel online does not support files bigger than 50 Mb, this is so lame.
Graeme Akerman commented
It works if the target and source files are in the same directory but not if they are in different directories which is very limiting. the same domain is used, when the folder paths are different, is tries to connect then says "Unable to get to file" but if in the same dir, no problem.
Lorenz Michels commented
I totally agree with @JV. And @Mikhail, ok, it is better than nothing, but I prefer to keep using the best...Google Spreadsheet.
@Microsoft, when do you finally catch up?
Finally ! It´s working !!
We waited 6 years for extremely subpar 2009 Google Sheets link sharing functionality - bye
A step in the right direction but it's not as good as Google Sheets by a long shot.
If I open WB1 and edit, I have to close that workbook to see the change in WB2.
WB2 does not refresh automatically even with the box checked. I have to hit the arrow to see the change. WB2 has a security warning on open that I need to hit every time to even enable the workbooks.
Google Sheets allows me to authorize access just once, and then every time going forward it works without needing to hit a button to allow permissions. Google Sheets also updated completely and immediately - no needing close workbooks, hit refresh arrows, wait for syncing, etc. If I have two workbooks open on separate computer screens and make a change in one, it appears on the other without delay. That's where we're trying to get with this.
It's better than nothing, but, let's say I have WB1 with source data, then I import it into WB2 though the link and then I need aggregated data from WB2 to be imported into WB3.
So the problem is that WB3 wont update if I change WB1 because in the middle autorefresh doesn't work due security reason in WB2, which tells me each time re-confirm I allow refreshing from WB1 even after I already allowed it initially.
After receiving an email from MS saying this feature is now added, I thought I'd better try it.
Its not working well. I opened up two online Excel sheets and created some linked cells from WB1 to WB2. You can paste cell references but the values come up as '0'. When I pasted a 2nd cell reference, it showed as '0', but it updated the first. :-/
Then I opened WB2 on my desktop Excel. So I've got WB1 open in a browser, WB2 open in a browser and on the desktop.
If I make changes to WB2 it shows up within 2 seconds on the desktop WB2 and vice versa.
Links still not updating- how long should it take.
If I clicked on Update Links (under Data) it still doesn't update.
I would say Links between spreadsheets in Excel Online is not working correctly, the updates should happen immediately (or within 2 seconds)
MS please sort his out :-(
Nothing yet? I guess no one at Microsoft actually follows this thread.
Hi all, I tried the following comment and got excited as I thought it was working.
But the problem is that it's kind of static: When you change the figures in the array, it can't Xlookup it!
This is the comment I'm referring to:
sebas commented on Links between spreadsheets in Excel Online
Just to let you know folks that it already work !! ... not as easy as I would like it to be from the web interface. but it work !!!
I use it with xlookup. you just need to replace the usual local xls filename with something like this 'https://*mysite*.sharepoint.com/sites/*sitename*/*FolderA*/[EXCEL File Name.xlsx]tabname' and you're in business.
I discovered that by using two excel file from sharepoint in excel desktop. The links created themself when I did a standard formula creation.
let's give a try !
Anonymous, yes i'm aware i'm saying functionally speaking a similar function to that of importrange, I used this example because unfortunately many have been moving to Google Sheets (myself included for my own business) but those stuck with Microsoft could use a similar function.
Adam, exactly it's difficult enough to make sure employees are using the correct tool for each application, with the workaround noted below they would have to have documents placed in Sharepoint as well as our other storage methods.
Adam Henderson commented
With so many points of entry (MS Excel, Excel online, Teams Documents, OneDrive, SharePoint) it is a bit overwhelming. And capability changes for each venue, it's a bit PentaPolar!
With all that being said, the function is working in SharePoint. However, what a pain to teach my company when and where to use each of these 5 tools.
@Jesse ImportRange isn't an Excel function, a simple cell reference across workbooks that works when the target workbook is closed is what's needed.
No... let us not validate a "workaround" this needs to be a proper functionality that doesn't require anything more than simple Importrange.
Ter uma função compatível com a IMPORTRANGE do Google
I think the most important thing to understand here is typically MS works on the premise that they don't actually have to improve things that there is no good substitute for. I deal with this same issue in Outlook. Just about any free email client can do more than Outlook (mail merge that is not a soul crushing activity, per account settings, proper caching that works without breaking storage or your syncing, and so much more it makes my soul hurt to be the Exchange/o365 admin).
Teams is getting focus because Zoom is taking the limelight away from it with features being released so fast (Teams was behind on some anyways). I would love to see that much dedication put into all of the office products. It does seem to be scaling up somewhat due to the number of people working from home and businesses that needed to work remotely at the moment.
I'm not saying there isn't progress being made, but quite a bit of what is working on is new features and not so much catching up with the competition. And while I'm ranting... maybe work on some of those "We don't recommend setting it up this way, but it's the only way it works" issues with Outlook.
Sorry... just trying to vent a few frustrations. I also would love to see this working. Currently trying to convince a group to stop using Excel as a database and something as simple as pulling data from other sheets could help them with this simple issue if a database setup will not.
Martin Smith commented
I'm with Ers on this one. What the **** is going on?
Roadmap status is 'Rolling out' also?
Please can we have an update.
If you need testers, I'm sure the majority on here can help!
Back in Feb 29, 2016 Yigal Edery acknowledged the problem by saying "Thanks for raising this. I assume you mean having a cell value linked to a value in a different spreadsheet. We’ll add it to our backlog. Keep voting!" That was 5 years ago.
Then back in Dec 21, 2018 Micah M from Excel Team said they started planning of this project. That was over 2 years ago.
And finally back in Oct 21, 2019, David from Microsoft Excel Team said he was excited to let us know that the work for External Links for Excel on the web has started!!!! YAY... That was about a year and a half ago.
All these happening while the biggest competitor of Microsoft (hint: starts with G...) already has this feature for YEARS!!!!
I wonder what MS is working on all these time? Are they trying to land the man on Mars????
This is a request where UserVoices go to die slowly with Microsoft looking down at us in the mud pit asking for a rope!
Microsoft, always late to the show just like it's browsers coming up with "new features" already available for a while with other browsers :P