If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find differences between two Excel workbooks or worksheets | savage_planet | General Discussion | 0 | September 19th, 2005 09:27 PM |
suddenly my excel workbooks are "shared workbooks" | Maggie's mom | General Discussion | 1 | August 28th, 2005 09:20 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Linking Excel data through Access to use a Form as an Interface | Laura | Links and Linking | 0 | March 23rd, 2004 03:59 PM |