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
FP&A Manager commented
Came here looking for answers as I thought for sure I must be missing something... Shocking that this isn't a feature yet--renders the tool almost useless. Linking between spreadsheets is INTEGRAL.
IT Manager commented
Urgently needed! Oct 21, 2019, Devs say they're working on it. Any ETA or updates?
Our company was about to abandon GSuite and migrate to O365 Sharepoint, but when we discovered this critical functionality missing from Excel Online, I cancelled the project. Extra $$$$ of revenue for Google that MS is missing out on capturing...
It's so frustrating that 2 online excel sheets cant be connected by any means..... no formulas no data queries. nothing works. I think Microsoft needs to take long hard look at their product and understand customer needs here... I can see threads going on since 2016 here where people are complaining the same thing... I Microsoft is just acting dumb and not doing anything around it.... pathetic...
Moi qui pensait lors du passage à Microsoft 365 que "forcément", cela existait chez Microsoft, nous venions de la suite Google..... et bien non, c'est une usine à gaz pour récupérer des infos sur plusieurs fichiers alors qu'avec la fonction "Importrange" de Google, la concaténation de fichiers budgétaires par exemple est un jeu d'enfants......Au secours, quand cela sera disponible !!!!!!!
We just switched to Microsoft 365 and now we are forced to completely change how we invoice and pay our contractors due to the inability for one of the biggest tech companies in the world to figure out how to link spreadsheets. I told my bosses that Google does it better but they didn't want to listen. Now we're all screwed. Thanks Microsoft. I will absolutely NOT recommend you to anyone. Such a let down ...
What David means to say is that he's wrote it down on the corner of a projections report that was shredded last year. This hasn't even made it to the drawing board far as I can tell, with little to no updates, and an obvious need for this functionality. If not for my companies antiquated practices we would likely shift to Google Suite as so many others have as well; I have in my personal business to be sure.
I'm glad to hear that external links in MS Excel Online are in workprogres.
I was searching for that possibility a few years ago. Better better late than never. Google is far ahead from You.
Any dates, when it could launch?
You could also add differentiation in sharing for read only, comments, edit instead of read only, and edit only.
Mitzi leatherman commented
I have worked with Excel since the "Lotus vs Excel" inception. I have always found Excel to be a powerful financial tool.
However, the Office 365 has basically shut down Excels usefulness. i have tried every work around with no success to link workbooks. When you have several departments with their individual budgets and expenses, you need to be able to consolidate that data to one workbook, which will constantly update based on the changes with the source workbooks.
How does Microsoft not know this is one of the most important features of Excel?
Gareth Stott commented
You want people to move to O365 Online.....give them a reason to want to, like the functionality of the desktop app.
I hate to say that but after 20+ years of using Microsoft Office, I and my company are finally moving to Google Docs for one simple reason; NO LINKS BETWEEN SPREADSHEETS...
I have been waiting to hear something back from MS Team on this, hoping that they can add this to Microsoft 365 but still nothing after almost a year. We cannot wait any longer to go on cloud and had to make a decision. I know we are not a huge company, just 250 employees, but if MS doesn't take care of their customers and small businesses like us, it won't end good for them.
Setting up an entire cloud account for 200+ employees is not an easy task and definitely not easy to switch back and forth. Once companies, like us, go to Google, they wont come back to MS...
Ryan Seitz commented
Any update on this?
Adam Henderson commented
Absolutely critical. Lacking this feature diminishes our use of Excel by 60%. I would break that down for you, but the data is in another spreadsheet and I am unable to share it across documents.
Alex Gabb commented
I'm shocked at the poor quality of Microsoft's online offering compared to Google Sheets. =IMPORTRANGE is just one of the many great innovations missing from Excel Online.. Google keep developing it and Microsoft haven't even implemented a basic version of it yet.
Microsoft are so behind the times. Excel online is useless! compared to Google Sheets. Forced by our company to use Microsoft but I would not recommend them at all. There are forums dating back to 2015 where people are complaining about not being able to link to Excel online documents.
m v ruijven commented
The links between the spreadsheets wich are stored on Onedrive only work when all connected spreadsheets are opened all together. Not when one of the connected spreadsheets are closed and stored on Onedrive.
Makes the computer very slow and takes away a lot of Excel's funtionality.
when the lookup function will be able to use in the onedrive sheets?
Chuck B. commented
Why is an analog to Google Sheets' "importrange" function not available? Our company just switched, and it's completely derailed all the report automation I've created.
Yes please, Google Sheet has this from the get go....
I would like to correct my fellow commentors .. this is not a FEATURE!!! This is an error. A bug. A mistake. Call it whatever tickles your fancy and gets it FIXED ASAP. What. The. Actual. F***?
This post is a five-year-old one... Seems that it's complicated... importrange exists in gsheet for a least a decade... what a shame...