Linking workbooks in Excel

[Guest]

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.

 

[Max]

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.