want excel 2007 to stop calculating processors
Hi
Or without going to Options
Formulas tabCalculation Optionsmanual
--
Regards
Roger Govier
trip_to_tokyo wrote:
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
|