How to Link addresee Current Value of power qry to the cell in sheet

Chaturvedi, Santosh 450 Reputation points
2026-09-30T09:10:54.6066667+00:00

I have on requirement-- See below..

  1. I have power qury addresee as shown in Current Value. and the power qry table is in cell C125 of excel sheet.
  2. The same addresee is required to be in one cell "I121" in excell sheet
  3. I wan to link the power qury addresee as shown in Current Value to the cell "I121" osf excel shhet, so that when i update current value addresse in power qury the "I121" also updates irself.

Please adice

User's image

Microsoft 365 and Office | Excel | Other | Windows
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Thomas4-N 22,380 Reputation points Microsoft External Staff Moderator
    2026-10-03T13:52:50.3333333+00:00

    Hello Chaturvedi, Santosh,

    Thanks for the clarification. I understand you want the Power Query source address to follow I121, not to copy a Power Query result into I121.

    In your screenshot, I121 displays 922, while its formula refers to E10 in another workbook. The Power Query parameter contains a file path. If Power Query reads I121 as a cell value, it would get 922, not the file path shown inside the formula.

    Do you want Power Query to use the workbook path embedded in I121’s formula, or would you prefer to put the file path as text in a separate worksheet cell and have Power Query read that cell? Once I know which you mean, I can give you the appropriate steps without changing I121’s existing formula.

    Was this answer helpful?

  2. Chaturvedi, Santosh 450 Reputation points
    2026-09-30T09:14:43.9033333+00:00

    Please notice that "I121" is having teh addresee

    ='Q:\Presentations\PE_31\O_Analysis and calculation\Fatigue\Backups_Marcros\Fatigue Assesment_as per 17949_Welded Joints\2_Preprocessing_DB_Data\Preprocessing_DB Collective_1[Preprocessing_DB_Data_C1_RSL31.xlsm]C1_RSL31'!$E$10

    and

    Power qury file path is

    Q:\Presentations\PE_31\O_Analysis and calculation\Fatigue\Backups_Marcros\Fatigue Assesment_as per 17949_Welded Joints_addresse\2_Preprocessing_DB_Data\Preprocessing_DB Collective_1\Preprocessing_DB_Data_C1_RSL31_Power_Q.xlsm

    I want power qury addresee same as "I121"

    Was this answer helpful?

    0 comments

  3. AI answer

    2026-09-30T09:11:26.11+00:00

    Use a cell reference or a linked cell, not a hyperlink.

    If the Power Query result already appears in the worksheet, link I121 to that result cell:

    1. Select the cell that contains the Power Query value to mirror.
    2. Press Ctrl+C.
    3. Select cell I121.
    4. Go to Home > Paste > Paste Link.

    Excel creates a cell reference in I121. When the source cell changes after the query is refreshed, I121 updates to the same value.

    If the Power Query value is already in a worksheet cell such as C125, I121 can also be set by entering a direct reference formula like:

    =C125

    If the value is on another worksheet, use a worksheet reference instead. The Paste Link command is the easiest way because Excel inserts the correct reference syntax automatically.

    If the parameter is currently Connection only and not loaded to a worksheet cell, first load the needed value to a worksheet cell, then link I121 to that cell.

    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.