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