Mar 11 2019 10:56 AM
I want to know if there is a way to import data from an Excel Online workbook to another one, just like I do in Google Sheets with the formula IMPORTRANGE(). All the data should be kept in the cloud (OneDrive). I will be reading your comments. Thanks!
Jul 08 2020 06:51 PM
@ElizabethLoro much to my dismay this is currently not possible.
This is literally the only thing that keeps me with google sheets at the moment.
Oct 30 2022 10:07 AM
@pkatelaanWDIT Not having import range is also why I miss Google Spread sheets. It made generating manual data entry tracking systems so easy.
Feb 11 2023 08:31 AM
@ElizabethLoro The lack of importrange (dynamic loading of ranges from another online sheet) is the main reason my company will not switch to Excel, along the fact that you cannot use named functions and named ranges in the online version (you need to create these offline). Microsoft forces its user to use the offline version of Office to do anything useful and this goes counter how most companies now use the cloud to do their work (nothing remains on your PC).