Linked Sheets

[tomic]

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]

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]

Thanks Dave,

That's what I was thinking too. I'll just have to figure out how I'm going
to work that into my process.

Do you know if there is a way to clear the data from a group of cells via a
macro or some other function automatically?

Tom

 

[Dave Peterson]

You can record a macro
(Tools|macro|record new macro in xl2003 menus)

Then select the range to clear
then hit the delete key on the keyboard to clear the contents of the selected
range.

Then stop recording the macro.