Share via

How can I link cells between Excel workbooks?

Anonymous
2023-05-15T21:16:10+00:00

I've built a spreadsheet to hold timing records for a model airplane competition. I'd like to have a second spreadsheet open on my second monitor so that the competitors can see their results and standing. Ideally, the second spreadsheet is an independent Excel file from the Excel source file. How can I link the mirrored file cells to my source file cells so that they'll update dynamically as I update the source file?

Microsoft 365 and Office | Excel | For home | 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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-05-15T21:37:48+00:00

    With both workbooks open, activate the workbook and worksheet where you want to create a link.

    Type =, then switch to the other workbook and worksheet, and click on the cell you want to link to.

    Press Ctrl+Enter to confirm the formula.

    You'll see the link formula in the formula bar.

    Repeat for other cells as needed.

    Switch back to the other workbook and close it (save it if necessary).

    Excel will have added the path of the 'source' workbook to the formulas.

    Save the workbook with the formulas.

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-05-15T22:05:10+00:00

    Thanks, Hans!

    That's basically what I was trying, but it didn't work. My error was that I was selecting one cell at a time. I got it to work when used the =valuetotext function and selected the entire range of columns on one row.

    This was a very good solution to my problem! I knew that I could duplicate my desktop to a second public-facing monitor, but I only wanted the public to see summary sheet - even if I had to edit the underlying data on other tabs. This way, I can use the source spreadsheet as I need, and the second "Mirror" spreadsheet is open on the public monitor with the summary data.

    -Kurt

    0 comments