Data in power uqry does not updated when source file cahnges its data

Chaturvedi, Santosh 450 Reputation points
2026-10-01T08:30:03.33+00:00

DATA IS FAKE & NOT REAL --> ONE EXAMPLE ONLY

There is one pronlem--

The souce file have data having array formula like which is a short tabular data (i named is as FINAL FILTER containg data from cell C13 to E935) )

=LET(

sa,$K$11:$DF$12,

sm,$J$13:$J$1000,

vals,$K$13:$DF$1000,

r,ROWS(vals), c,COLUMNS(vals), seq,SEQUENCE(r*c),

flatVals,TOCOL(vals,0,TRUE),

flatSa,INDEX(sa,1,ROUNDUP(seq/r,0)),

flatSm,INDEX(sm,MOD(seq-1,r)+1),

keep,(flatVals<>"")*(flatVals<>0),

HSTACK(FILTER(flatSa,keep),FILTER(flatSm,keep),FILTER(flatVals,keep)))

I have other new sheet where i made teh power qury and get this FINAL FILTER containg data from cell C13 to E935) )

The problem is that when the source data changes its values in any cell data in power qury data does not changes.

User's image

Microsoft 365 and Office | Excel | For home | Windows
0 comments

2 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Thomas4-N 22,380 Reputation points Microsoft External Staff Moderator
    2026-10-04T06:26:44.67+00:00

    Hello Chaturvedi, Santosh,

    If I understand correctly, the formula result changes in the source sheet, but Power Query still shows the old values.

    Could you save the source workbook, then select Data > Refresh All in the workbook containing the query? Does the result change after that, or does it stay the same?

    If it stays the same, please share what the query’s Source step points to, such as a worksheet, a fixed cell range, or the FINAL FILTER named range. That will help distinguish a refresh issue from how Power Query is reading the formula-generated data.

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-10-01T08:30:22.71+00:00

    Power Query does not automatically refresh its local cache when the source changes. If the source range is driven by formulas, the query can continue showing cached results until it is refreshed.

    Use this refresh path:

    1. In Excel, select a cell in the loaded query table.
    2. Select Query on the ribbon.
    3. Select Refresh > Refresh.

    That refresh updates both:

    • the worksheet query result
    • the Power Query cache

    If the issue is only inside the Power Query Editor preview, refresh the preview there:

    1. Open Power Query Editor.
    2. Select Home.
    3. Select Refresh Preview > Refresh Preview or Refresh All.

    Important detail:

    • Refreshing in Power Query Editor updates the local cache, but it does not update the query already loaded to the worksheet or Data Model.
    • To update the worksheet result, refresh from the worksheet query as described above.

    Also check these common causes of stale or incorrect refresh results:

    • If a yellow bar says the preview may be old, the local cache is out of date. Select Refresh.
    • If the source file is open and not saved, changes are not included in refresh until the file is saved.
    • If the source file is open and locked, Power Query may not be able to access it until it is closed.
    • If table names, column names, or data types changed, refresh can fail or return unexpected results.

    For formula-driven source data, a practical check is:

    1. Make sure the formula results in the source sheet have already recalculated.
    2. Save the source workbook if the query reads from that workbook.
    3. Then run Data > Refresh All or Query > Refresh.

    If the source location may change later, use a Power Query parameter for the file path so refresh errors are easier to avoid.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.