Linking Worksheets
 

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.
--

Thanks so much
Lele

Linking Worksheets
 

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

--
Don Guillett
SalesAid Software

"Lele" wrote in message
...
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.
--

Thanks so much
Lele

Linking Worksheets
 

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

On Sun, 11 Feb 2007 14:23:01 -0800, Lele wrote:

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.