Power Query Problems

Fix Power Query Values That Do Not Match Excel Source Data

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

The user needs Power Query to import values that match the calculated results visible in an Excel source workbook.

Fix Power Query Values That Do Not Match Excel Source Data
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
A query imports data from an Excel workbook containing formulas or lookups.
Observed behavior
Some imported values differ from the calculated results displayed in the source workbook.
Before you start

Identify a specific mismatched row and column, and confirm which workbook and sheet the query uses as its source. Make sure the source workbook and any lookup data it depends on are available.

Solution 1Recommended

Recalculate the source workbook and inspect the query

Use this method first when the source contains formulas or lookup results that may not have been saved after recalculation.

1
Check the source formula

Open the source workbook in Excel, select the mismatched cell, and inspect its formula in the formula bar. Check the referenced lookup range and source data for the expected value.

2
Recalculate and save

Select Formulas > Calculation Options > Automatic, then choose Formulas > Calculate Now. Confirm the result in the source cell and select File > Save.

3
Verify the query source

In the workbook containing the query, open Data > Queries & Connections, right-click the query, and select Edit. In Applied Steps, select Source and confirm that it points to the intended workbook.

4
Check transformations and refresh

In Power Query Editor, select each Applied Step and watch where the value changes. Review steps such as Changed Type, then close the editor and use Data > Refresh All to reload the query.

Recalculate the source workbook and inspect the query
Check displayed formatting: Excel formatting can make an underlying value look different from the imported value. Compare the underlying value and data type as well as the visible display.
Free Microsoft Office alternative

Review Excel Source Data with WPS Spreadsheet

WPS Office is a free, lightweight alternative for reviewing spreadsheet data in a familiar interface. Open compatible Excel files to inspect source values and formulas while moving between Office applications. It does not fix Microsoft Excel Power Query issues.

Inspect spreadsheet values and formulas in WPS SpreadsheetOpen and edit compatible Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transition from ExcelWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query show an old formula result?

The source workbook may not have been recalculated and saved with the latest result. In Excel, select Formulas > Calculate Now, save the source workbook, and then use Data > Refresh All in the query workbook.

How can I tell whether a query step changed a value?

Open Data > Queries & Connections, right-click the query, and select Edit. Select the Applied Steps one at a time to see where the value changes, paying particular attention to type conversions.

Can a VLOOKUP result cause a mismatch?

A VLOOKUP result can differ if its lookup data has changed or the workbook has not recalculated and saved. Select the source cell, inspect its formula and lookup range, then recalculate and save before refreshing the query.

Does saving as CSV preserve Excel formulas?

No. A CSV stores the exported sheet's values, not its formulas. Use File > Save As with a different filename to create a CSV for checking the disputed value.