Forum Discussion
LINKING TWO EXCEL FILES ON SHAREPOINT
Hello there, I've been having a problematic I'm trying to solve, I think it is very easy, but don't find the way to do it, so I thought asking directly would be easier 😉 So, I have two exc...
So to my knowledge an in cell formula like that will not update unless that other workbook is also open. A better way is to use Power Query (Data -> Get Data). That said, I would consider the 'master/mother' to be the sheet with all the data in it. You add calculations columns or query data from that data import but I'm concerned if you add hard coded values to rows they may not line up after an update. I'm not expert in Power Query, and only have used it to query data for processing and not ever tried adding data (mainly because I didn't think it would work but the power of excel has surprised me often)
mtarler Not for the Mac, I'm afraid!
- What about Power Automate? liseg95, you said they are on Sharepoint:
Excel Online + Power Automate
Create flows that automate repetitive work tasks with Power Automate—and trigger right from your Excel data. Download the app
I have used Power Automate to automatically update an Excel file based on form inputs but maybe you could do excel to excelmtarler That I don't know. Have no experience with PA.
Riny_van_Eekelen mtarler thank you for taking the time to think about my issue,
Isn't there a way to just simply mirror an excel file on another one ? 😞
