MrExcel Publishing
Your One Stop for Excel Tips & Solutions

linking sheets in different workbooks


Posted by Greg on January 11, 2001 10:35 AM

Is it possible to link an entire sheet to another sheet in a totally different workbook. Example: Job info in c:\jobinfo and have a copy on the server u:\Jobinfousers. What I am trying to do is make the workbook on the server a mirror image of a couple different workbooks. I have job workbooks that have up to 20 sheets and one of those sheets is a summary page. I want to put the summary page from each of the jobs onto one spreadsheet on the user drive so others can look at that instead of the main spreadsheet I work with. Is it possible?


Posted by Robert on January 11, 2001 5:25 PM

Yes, this is possible.

the formula in each cell should reference the workbook/worksheet as follows in book1:
=[Book2.xls]Sheet1!$A$1.

There is a snag though, if both books are open, and you insert a row/column in book1, it will not show up in book 2... therefore it is handy to use a copy for updating and a briefcase function to update the referenced directory for your users, so you do not run into that probelm...

R.