Prev: view cell fill colour on screen
Next: excel versions
From: Johann Terblanche Johann on 12 May 2010 04:28
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
From: trip_to_tokyo on 12 May 2010 04:52
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
From: Roger Govier on 12 May 2010 05:04
Hi

Or without going to Options
Formulas tab>Calculation Options>manual
--
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
 | 
Pages: 1
Prev: view cell fill colour on screen
Next: excel versions