View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default 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.