Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking workbooks in Excel
I'm trying to link two workbooks. The information I enter in the first
workbook is the master copy and I would like this same information to be updated in the second workbook. I use the second workbook as the updated status which I send to clients. I usually create two workbooks and then enter the information twice, once in the master workbook and again in the client's copy - tedious and incorrect, I'm sure. Thank you for your help. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking workbooks in Excel
Just some thoughts .. if the 2 books were identical (probably not?),
just send over a copy* of your master would satisfy ? *say, a frozen copy w/o any formulas but with all formatting intact. In the copy, we could kill all formulas in all sheets at one go using sheet grouping, and then doing an "in-place", entire sheet: Copy Paste special Check "Values" OK, taking care, of course, to immediately ungroup the sheets thereafter. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Anton" wrote in message ... I'm trying to link two workbooks. The information I enter in the first workbook is the master copy and I would like this same information to be updated in the second workbook. I use the second workbook as the updated status which I send to clients. I usually create two workbooks and then enter the information twice, once in the master workbook and again in the client's copy - tedious and incorrect, I'm sure. Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Large Access Table into Excel | Links and Linking in Excel | |||
Linking WorkBOOKS across directories | Excel Worksheet Functions | |||
Linking Excel columns in two different excel programs | Excel Discussion (Misc queries) | |||
Linking Excel to Outlook?? | Excel Discussion (Misc queries) | |||
Can't alt-tab between Excel workbooks in one session. Help! | Excel Discussion (Misc queries) |