Calculating cells

[Gor_yee]

I got heaps of data in a spreadsheet, about 30000 lines with formulas
and VLookups...my question is, when ever i make some adjustments to
the cell, it starts calculating and it takes so long...is there a way
for me to turn this function off???Thanks all

 

[Ron Coderre]

From the Excel Main Menu:
<tools><options><calculation tab>....Check: Manual calculation

When done....reset it back to Automatic

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[Guest]

Yes you can turn this off, it's easy.

Go to Tools then Options.

Then click on the Calculation tab.

The first thing under calculation is how you want it to calculate -
automatically, automatically except for tables, and manually. Select manual
then click OK.

When you're ready to recalculate your sheet, press the F9 button and this
will do it for you. But don't forget that you've got it turned on!

I think this is a global setting so you need to remember when you open
another spreadsheet that it won't automatically recalculate. But it only
takes a second to press the F9 button.

Hope this helps!

 

[Pete_UK]

Click on Tools | Options | Calculation tab and select Manual rather
than Automatic calculation mode, then OK. If you want to recalculate
you press the F9 key.

Hope this helps.

Pete

 

[Gor_yee]

Yes you can turn this off, it's easy.

Go to Tools then Options.

Then click on the Calculation tab.

The first thing under calculation is how you want it to calculate -
automatically, automatically except for tables, and manually. Select manual
then click OK.

Thanks for all your help...

 

[Guest]

I find working without automatic recalculation to be too annoying and will
freeze the vlookups by Copy and PasteSpecial>Values. That loses the
formulas, so before that, save one as text (add ' on front) and set aside.