Speed up calculation of a worksheet that contains formula

V

vennila

In my file i am having formulae (about 52 columns), while copying the formula
the calculating cells take huge time. How to improve the speed?

Vennilla.
 
A

aidan.heritage

Turn the calculation to manual - then it will ONLY recalculate when you
want it to
 
P

Pete_UK

Also, once the results are calculated, you can fix the values unless
you really want to keep the formulae - highlight all the cells with
formulae in, click <copy> then Edit | Paste Special | Values (check),
OK, then <Enter>.

Hope this helps.

Pete
 
Top