Forum Discussion
Excel Workbook Link Source from 1 workbook tab to another
Hi,
I've seen some similar posts but not sure if what I am looking for is correct. But here goes.
Because it involves work, I'll say Workbook A and B.
The idea is taking Tab 1 of Workbook A and linking it into Tab 3 in Workbook B and then have it automatically refresh when we update Workbook A Tab 1.
Now I understand that this has to be a workbook link source. I did try and highlight all of Tab 1 Workbook A and then Pasted it into the Tab 3 of Workbook B and I was able to do Paste > Link Source and click on automatic refresh. But all I got was #Connect in all the cells of that tab.
So I'm not sure if I was on the right track and I simply need whoever created Workbook A's permission to do this or I need to do something else.
1 Reply
When you paste as a link, Excel inserts formulas in the format:
='[Workbook A.xlsx]Tab 1'!A1
This means that each cell in Workbook B is referencing the corresponding cell in Workbook A.
Ensure the full path to Workbook A is accessible, especially if stored on a network.
Some older versions of Excel or web-based Excel (Excel for web) might not fully support automatic updates for linked workbooks.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
