Forum Discussion

Copper Contributor

Sep 25, 2020

Solved

Linking Excel tables in two workbooks (one stored locally and one on OneDrive)

Hi everyone, I have a table in an .xlsm file stored locally, and I would like to link the data to an .xlsx file stored on OneDrive. The goal is to have the tables synchronized, so any data chang...

excel

Excel for web

NikolinoDE
Sep 25, 2020
Asirbu
If you allow, here is a little thought-provoking aid / information about your plans.
Differences between using a workbook in the browser and in Excel
https://support.microsoft.com/en-gb/office/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6?ui=en-us&rs=en-gb&ad=gb

Get data from Excel workbook files
https://docs.microsoft.com/en-gb/power-bi/connect-data/service-excel-workbook-files

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

NikolinoDE

Platinum Contributor

Sep 25, 2020

Asirbu

If you allow, here is a little thought-provoking aid / information about your plans.

Differences between using a workbook in the browser and in Excel

https://support.microsoft.com/en-gb/office/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6?ui=en-us&rs=en-gb&ad=gb

Get data from Excel workbook files

https://docs.microsoft.com/en-gb/power-bi/connect-data/service-excel-workbook-files

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

Asirbu

Copper Contributor

Sep 25, 2020

Thank you so much for sharing these articles NikolinoDE ! Saving it as an .xlsb did the trick.

I was able to use it in Power Automate without having to go through the pain of creating an additional .xlsx file, and figure out how to link the data between the two. Much appreciated!

NikolinoDE
Platinum Contributor
Sep 25, 2020
Your welcome.
I was pleased to be able to help you with my humble knowledge.

Nikolino
I know I don't know anything (Socrates)