If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
want excel 2007 to stop calculating processors
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|