want excel 2007 to stop calculating processors
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.
"Johann Terblanche" wrote:
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
|