You’re offline. This is a read only version of the page.
Announcements
Hi,
I have several Excel files in SharePoint, and a Master Excel file also in SharePoint. What I am trying to figure out is how or if it is possible, that when any of the individual Excel files are changed, that those changes can also automatically flow into the Master spreadsheet. Any ideas?
Thanks,
Kevin
Hi Kevin,
if you have links (with formulas) between the excel-files the master file should be updated every time you open it. For that you don't need power automate.
With power automate you would have to create tables (if they do not already exist) within the excel files to read them out automatically and update the rows in the master file identified by a key column. You could move all the sub-files into one folder and create the trigger when a sharepoint-file is changed within that folder. I guess it should recognize it when data in the excel file is changed.
Share
Report
All responses (
Answers (
501
