Fix Power Query Values That Do Not Match Excel Source Data
Question details
The user needs Power Query to import values that match the calculated results visible in an Excel source workbook.

- 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.
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.
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.
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.
Select Formulas > Calculation Options > Automatic, then choose Formulas > Calculate Now. Confirm the result in the source cell and select File > Save.
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.
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.

Test the source values in a CSV or new workbook
Use a separate test file to determine whether the discrepancy comes from the source workbook or the query.
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.

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.




