How To Link a CSV file to an Excel Workbook on OneDrive

guptilious 

Excel for web: Include data from linked workbooks

The browser version of Excel has been expanded to include another functionality that was previously only available in the desktop versions for Windows and Mac. In the future, it will be possible to include data from linked workbooks and have it updated automatically.

The new function is already finished and is now being gradually distributed to all users. Logically, the linked workbooks must be stored in OneDrive or SharePoint so that they can be accessed in the browser.

If you have opened two workbooks and copied data from one to the other, these data are automatically linked to one another. If they change later in the source, they are also updated at the destination - just as we have known from the desktop version of Excel for years.

You can of course also create the link "on foot" by entering the reference to the data to be integrated in the familiar Excel format:

= ‘https: //domain/folder/[filename.xlsx] sheet‘! Cell_or_area

Of course, you need appropriate access rights to be able to integrate the data, but that's not new either. The links created in this way can then be managed via the menu bar; here, for example, you can set whether the update should take place automatically or manually. References that are no longer required can also be removed at this point.

I hope I could help you with this information.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.