Share via

Two-way linking between Excel Workbooks

Anonymous
2023-03-23T08:16:47+00:00

I have two Excel workbooks: Input and Calc. Calc does some calculations using values from Input and the results are shown in Input workbook. When Calc is closed, how can I get the results for different values from Input? I can read data from Calc when it is closed but cannot change values or evaluate formulas in it without using VBA.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-23T08:57:08+00:00

    Hi Husnain

    I'm AnnaThomas and I'd happily help you with your question. In this Forum, we are Microsoft consumers just like yourself.

    To establish a two-way link between the workbooks, follow these steps:

    1. In the Calc workbook, select the cell that you want to link to the Input workbook.
    2. Click on the formula bar and enter the following formula: =‘[Input.xlsx]Sheet1’! A1 (Replace ‘Input.xlsx’ with the name of your Input workbook and ‘Sheet1’ with the name of the worksheet that contains the data you want to link to).
    3. Press Enter to complete the formula.
    4. The cell in Calc should now display the value from the corresponding cell in the Input workbook.
    5. To establish a two-way linking, select the cell in the Input workbook that you want to link to.
    6. Click on the formula bar and enter the following formula: =‘[Calc.xlsx]Sheet1’! A1 (Replace ‘Calc.xlsx’ with the name of your Calc workbook and ‘Sheet1’ with the name of the worksheet that contains the data you want to link to).
    7. Press Enter to complete the formula.
    8. The cell in Input should now display the value from the corresponding cell in the Calc workbook.
    9. Any changes made to linked cells in either workbook will be automatically updated in both workbooks.

    I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

    Best Regards,

    AnnaThomas

    Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

    3 people found this answer helpful.
    0 comments