Linking two excel files
 

I have a status worksheet that I update daily with both text comments and
figures. My PM also has a worksheet that he updates. Both worksheets are
similar but not identical. Is there a way I could link specific cells so
that when I update data in my workbook, it will update his (whether its text
or numberic)?

Vikki,

Links are one-way. One cell contains the data, the other contains the link
to it. So your PM and you can't happily update a worksheet, and see each
other's changes. If you have a link in his sheet to yours, he can't type
anything in -- to do so would replace the link in the cell.

A shared workbook would allow that (though you don't see the updates in real
time), if you want to open that bag of worms. There seem to be a lot of
problems with shared workbooks.

To set up a link, copy the cell that will contain the data (yours, in your
example), and in the linked cell (his), Edit - Paste special - Paste link.

If this is table type data, consider Access -- it's multiuser. If it's
random stuff, never mind.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Vikki" wrote in message
...
I have a status worksheet that I update daily with both text comments and
figures. My PM also has a worksheet that he updates. Both worksheets are
similar but not identical. Is there a way I could link specific cells so
that when I update data in my workbook, it will update his (whether its
text
or numberic)?