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.

​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.  Read More

​