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. |
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. |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com