Hard cells

S

Stephen

Hi,

I have a wookbook, say it is Workbook A, in which the
cells take calculations from another workbook, say
Workbook B. So A3 in Workbook A may read as 334.40 but
it is really a combination of A4 and A6 in Workbook B.

Here is my delimma. I want to email Workbook A to
someone but email not Workbook B.

Is there some way to turn A3 in Workbook A into a hard
number, 334.50, so that it will read that number when
they receive it?

Thanks a lot,

Stephen
 
J

J.E. McGimpsey

Copy the cell, then choose Edit/Paste Special and select the Values
radio button.
 
P

Peo Sjoblom

Select the sheets in workbook A, select all sheets by holding down shift
key
while clicking on the last sheet tab, press ctrl A to select all cells, do
edit>copy,
now do edit>paste special as values. Done, all formulas are now are now hard
coded
values w/o now click in the first sheet, to remove the all cells selection,
then right click any sheet tab and select ungroup sheets. Save the workbook
and email it
 
Top