want excel 2007 to stop calculating processors

[Johann Terblanche]

Hi There
I am running excel 2007. I have a sheet with 167000 lines in it, and have to
use vlookup to match fields from other files.

Once i made a change, the program start with "Calculating: (Processor) which
is taking up to an hour to complete.

How can i remove that calculating

Regards
Johann Terblanche

 

[trip_to_tokyo]

Office Button (top left hand corner)

Excel Options (lower right hand corner)

Formulas (left hand side) then, on the right hand side, under Calculation
options, set Workbook Calculation to Manual / OK

If my comments have helped please hit Yes.

Thanks.

 

[Roger Govier]

Hi

Or without going to Options
Formulas tab>Calculation Options>manual