Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked Sheets
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked Sheets
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked Sheets
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" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked Sheets
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. tomic wrote: 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" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Totals linked from other sheets | Excel Worksheet Functions | |||
Identifying Linked s/sheets | Excel Programming | |||
Linked sheets | Excel Discussion (Misc queries) | |||
linked sheets | Excel Discussion (Misc queries) | |||
Using SUMIF with linked sheets | Excel Programming |