Linking Worksheets

[Guest]

I use excel worksheets to prepare and e-mail proposals to clients. I want to
do the calculations in one worksheet and then view the summary figures in
another linked worksheet. Problem is I don't want my clients to see my
computations, however if I just send the summary worksheet without the other
(linked) worksheet I get all kinds of data reference errors.

What is the best way to ptrpare proposals which only show summary figures,
but which I can update and modify as need be.

 

[Don Guillett]

Have a macro either input the values only or change the sheet you send to
values.

 

[Gord Dibben]

Create a copy of the summary sheet and change the computed cells to values.

Copy that sheet to a new workbook and send that to the clients.

A bit more work, but if you don't want your clients to see your computations,
don't include them.


Gord Dibben MS Excel MVP