Power Query Problems

Sync a Local Excel Workbook with an Online Master File

Steve KSteve K Nov 18, 2026 869 views

Question details

Keep a local Excel workbook updated with data from an online master workbook without repeatedly copying and pasting.

Sync a Local Excel Workbook with an Online Master File
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the local workbook

Open the workbook that should receive the master data in Excel.

2
Connect to the master

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.

3
Choose the data

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.

4
Refresh the connection

Select Data > Refresh All whenever you want to retrieve the latest saved data from the master workbook.

5
Set automatic refresh

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.

Connect the local workbook to the master with Power Query
Keep the source available: The master file must remain accessible at the configured path. If it is in a synced folder, allow the latest online changes to sync to that folder before refreshing.
Free Microsoft Office alternative

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.

Open and edit spreadsheet data in a familiar interfaceCompatible with Microsoft Excel formats such as XLSXReview imported master data in a local workbookFree and lightweight office suite
microsoft office alternative - wps office

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.