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

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)

"Gor_yee" wrote in message
ups.com...
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

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!

"Gor_yee" wrote:

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

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

On Oct 18, 1:23 pm, Gor_yee wrote:
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

On Oct 18, 10:32 pm, lilo wrote:
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...


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!

"Gor_yee" wrote:
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

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

"Gor_yee" wrote:

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