Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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)? |
#2
|
|||
|
|||
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Excel files -- I cannot find an answer anywhere. | Excel Discussion (Misc queries) | |||
error opening excel 2000 files | Excel Discussion (Misc queries) | |||
Making files with excel | Excel Worksheet Functions | |||
Using large excel files | Excel Worksheet Functions | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |