Power qury table is not updated when the source file addresee is changed

Chaturvedi, Santosh 450 Reputation points
2026-09-29T15:47:20.86+00:00

I have one problem- I have made one power qury table and pasted in in cell 125, when i change the source file addrese in power qury , the values must change in power qury table and so in cell 125 where it pasted.

Thisis not happen -- pleae advice

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

5 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-09-29T15:47:36.34+00:00

    This usually happens for one of these reasons:

    1. The query source changed, but the query was not refreshed. After changing the source location, run Data > Refresh All.
    2. The source structure changed. Power Query depends on the original table and column names. If the new source file has renamed or missing tables, columns, or different data types, refresh can fail or return unexpected results.
    3. The value was pasted as static cells instead of being connected to the query output. If data was copied from the Power Query result and pasted into cell 125, that pasted range will not update automatically when the query changes. Only the loaded query table updates on refresh.
    4. The wrong worksheet may be getting edited. If the query was imported from an Excel table or named range, make sure changes are being made in the original source worksheet, not the worksheet that contains the loaded query.

    Recommended checks:

    1. Open Data > Queries & Connections and confirm the query still points to the new file location.
    2. In Power Query, check the Source step and update it if needed.
    3. Select Home > Close & Load after editing the query.
    4. Run Data > Refresh All.
    5. Verify that the new source file has the same table names, column headers, and compatible data types as the old file.
    6. If the source file path changes often, use a parameter for the file or folder path. Then only the parameter value needs to be updated, which helps prevent refresh errors.

    If the data must appear starting at cell 125 and update automatically, load the query output directly to that worksheet/range instead of copying and pasting values.

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

    Was this answer helpful?

  2. Chaturvedi, Santosh 450 Reputation points
    2026-09-29T15:52:37.22+00:00

    How to delete this row having following content in power qury

    User's image

    Was this answer helpful?

  3. Chaturvedi, Santosh 450 Reputation points
    2026-09-29T15:54:23.2833333+00:00

    How to delete this row having content mentioning Column 1,Column 2, Column 3 in power qurey

    Was this answer helpful?

    0 comments
  4. Ivory 1,825 Reputation points Independent Advisor
    2026-09-29T16:01:25.5966667+00:00

    Hi Chaturvedi,

    The AI-generated troubleshooting steps provide a great starting point for investigating the issue. Could you please try those suggestions first, and then help me verify the following details?

    1. When you change the source file address, does the preview in Power Query show the new data, or does it still display the old data?
    2. After selecting Refresh All, do you receive any error messages, warnings, or refresh failures?
    3. Is the new source file an Excel workbook, CSV, or another file type?
    4. Does the new source file have the same worksheet name, table name, and column headers as the original source file?
    5. In Queries & Connections, does the query status show Refresh completed successfully?
    6. If you right-click the query output table and select Refresh, does the data change?
    7. Does creating a new query against the same source file return the expected data?
    8. Has the source file been moved to a different folder, renamed, or replaced with a completely different file?

    To ensure I provide the most accurate assistance, I would appreciate any additional information you can share regarding your current situation. If possible, please include screenshots, as they can be very helpful in the investigation.

     

    Was this answer helpful?

  5. Ivory 1,825 Reputation points Independent Advisor
    2026-09-29T16:24:57.1233333+00:00

    Hi Chaturvedi,

    Column1, Column2, and Column3 seem to be column headers at the top of the table, not a row of data. Power Query generates those names when a table has no headers, and they aren't a row you can delete. Power Query always needs column names, so you can't have a table without them. You can rename them to something neutral, or load the data and delete the header row in Excel afterward.

    If the names are just placeholders and your real headers are in the first data row, please go to Home > Use First Row as Headers. The first data row moves up and becomes the header, and Column1/2/3 disappear.

    If you want to rename the headers yourself:

    1. Double-click a header (or right-click > Rename).
    2. Type the new name.

    If the headers were promoted earlier and you now want them gone:

    1. In Applied Steps, delete the Promoted Headers step (X next to it), or use Home > Use Headers as First Row to turn them back into data.
    2. Then use Remove Top Rows on the row you don't want.

    For reference: Promote or demote rows and column headers (Power Query) | Microsoft Support

    If the answer is helpful, please click 'Yes' and kindly upvote it.

    Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    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.