I don't think so.

I think that the owner of the Lab workbook would have to make the changes and
then save the workbook.

Then the owner of CK2 could update the values (by recalculating or using
edit|links|Update values (xl2003 menus)).



tomic wrote:

Is there any way to have a "live" link between two workbooks? I have two
workbooks, one called CK2 and the other is call Lab. I would like the data
that is entered into the Lab workbook to automatically be displayed in the
other workbook.

The workbooks will both be opened, and running simultaneously, by different
users. And because the workbooks are used everyday, I have it set up so that
the users can't save the master workbook - when they save the file, it is
really just saving a copy to a location on my network.

Is it possible to do this? Any suggestions or help would be appreciated.
Thank You!

--

Dave Peterson