Save Workbook but without Formulas (just values)
 

Hi,

I have an excel spreadsheet consists of 7 tabs with a mixture of of tables
and charts.

My basic problem is that when i try to use the autofilter module in some of
the tabs its taking a long time whilst the 'calculating cells 0%' messeage
appears. One idea i have is to use a macro (part of which is already in use)
to save a copy of the spreadsheet (already coded) but now what i want is to
remove all the calculations and formula's in the new copy and for them just
to be replaced with the calculated values from the original workbook.

Any ideas. Thanks In Adavnce

Save Workbook but without Formulas (just values)
 

Hi

See this page for a few examples
http://www.rondebruin.nl/values.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"sdg8481" wrote in message ...
Hi,

I have an excel spreadsheet consists of 7 tabs with a mixture of of tables
and charts.

My basic problem is that when i try to use the autofilter module in some of
the tabs its taking a long time whilst the 'calculating cells 0%' messeage
appears. One idea i have is to use a macro (part of which is already in use)
to save a copy of the spreadsheet (already coded) but now what i want is to
remove all the calculations and formula's in the new copy and for them just
to be replaced with the calculated values from the original workbook.

Any ideas. Thanks In Adavnce