Sync a Local Excel Workbook with an Online Master File
Question details
Keep a local Excel workbook updated with data from an online master workbook without repeatedly copying and pasting.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- A user wants to import data from an online master template into a local workbook and refresh it when the master changes.
- Observed behavior
- The local workbook should display updated master data after its query is refreshed.
Make sure you have permission to access the master workbook and that it is available through a synced local folder or an accessible network path. Identify the worksheet or table you want to import, and check that your Excel version supports Power Query.
Connect the local workbook to the master with Power Query
Use a Power Query connection to import master data and refresh it manually or at configured intervals.
This connection imports data from the master into the local workbook; it does not synchronize edits in both directions. Automatic refresh runs according to the available query settings, not necessarily as soon as the master changes.
Open the workbook that should receive the master data in Excel.
Select Data > Get Data > From File > From Excel Workbook. Browse to the master workbook in its synced local folder or accessible network location, and select Import.
In Navigator, select the required table or worksheet. Select Load to add it to the local workbook, or choose Transform Data if you need to adjust the query first.
Select Data > Refresh All whenever you want to retrieve the latest saved data from the master workbook.
Open Data > Queries & Connections, right-click the query, and choose Properties. If available, enable refresh when opening the file or refresh at a specified interval, then save the workbook.

Work with Excel-Compatible Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move existing workbooks between office suites. Use Excel for the Power Query connection described above; WPS does not fix or configure that Excel feature.

Frequently Asked Questions
Does Power Query update the local workbook immediately when the master changes?
Not necessarily. Use Data > Refresh All to update manually, or enable the available refresh-on-open or interval settings in the query properties.
Can I use a master workbook stored online?
Yes. One option is to make it available in a synced local folder and select that file through Data > Get Data > From File > From Excel Workbook. The latest online changes must sync to the folder before Excel refreshes the query.
Will edits in my local workbook update the master file?
No. The Power Query connection imports data from the master into the local workbook; it is not a two-way editing connection. Make source changes in the master and refresh the local query.
What should I check if the query does not refresh?
Check that you can open the master file at the configured path and have permission to access it. If it is in a synced folder, check that the folder has received the latest online changes, then select Data > Refresh All.




