Forum Discussion
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...
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
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)
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!
Your welcome.
I was pleased to be able to help you with my humble knowledge.
Nikolino
I know I don't know anything (Socrates)
I was pleased to be able to help you with my humble knowledge.
Nikolino
I know I don't know anything (Socrates)