Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 12th 10, 09:28 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 1
Default 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   Report Post  
Old May 12th 10, 09:52 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 833
Default 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   Report Post  
Old May 12th 10, 10:04 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 376
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 use multicore processors? Jim C Excel Discussion (Misc queries) 2 November 29th 06 08:48 PM
Excel and Dual processors sphbecker Setting up and Configuration of Excel 1 August 6th 05 07:49 AM
Different Processors with Excel... CLR Excel Discussion (Misc queries) 7 May 2nd 05 10:56 AM
Calculating Cells causes Excel to stop responding Marina Excel Discussion (Misc queries) 1 April 26th 05 06:19 PM
Excel and Hyper-Threading Processors David Benson Excel Discussion (Misc queries) 3 March 24th 05 07:11 AM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017