Linking workbooks

  • Thread starter Thread starter Matty
  • Start date Start date
M

Matty

Hi

A colleague has, for some reason, got two identical work books, one in his
own user drive, and the other in the personnel group drive. He would like to
have the workbook in the group drive update automatically when he updates
the workbook in his own user drive. I suggested just using the one in the
personnel drive, with the necessary permissions, but he would like to be
able to do it his way!!

My questions are: can this be done, and if so how?

We are using Office 2K.

Many thanks in advance

Matty
 
Open both books (Names will have to be slightly different), do Window / Arrange
/ Tiled, then click on a cell in his personal workbook that he would like to
update automatically, type = and then click on that cell in the other workbook
(May have to click twice - once to select workbook and once to select cell) and
then hit Enter. Copy the cell and paste special as formulas everywhere he wants
to be linked. Close Source workbook (ie the one on the public drive) and then
save the one on his personal drive. When he opens it will prompt for updates
and update if told to do so.
 
We have a situation where one person keeps all the data for a department
on a server, but wants each sub department to be able to see their own
data without having access to the rest of the department's data.
Solution--linked workbooks on separate shares on the server.
Unfortunately when the user opens the linked workbook and clicks yes to
update the links, it comes back to say that one or more links cannot be
updated. This defeats the purpose. Any help?
 
Back
Top