Prev: Comment in every 11th row
Next: what is ^ in a formula for
From: dcw13 on 7 May 2010 00:36
small worksheet. each time i enter a number in a cell i get the active
circle showing. i move to another cell but quite a delay time before freed
up for next entry. why?
From: RD on 7 May 2010 02:58
You have automatic Calculation on. By turning this off you will be able to
update you spreadsheet much faster.

To do this go to the Windows icon in the top left of the screen and click on
Excel Options. Then choose the Formulas button and under Calculation Options
choose the Manual radio button. Click OK.

Then your spreadsheet will only calculate when you hit F9 or close/save the
spreadsheet.

"dcw13" wrote:

> small worksheet. each time i enter a number in a cell i get the active
> circle showing. i move to another cell but quite a delay time before freed
> up for next entry. why?
From: dcw13 on 7 May 2010 11:01
RD will this work as you say for existing spreadsheets? or are there other
options i also need to have off?? thx

"RD" wrote:

> You have automatic Calculation on. By turning this off you will be able to
> update you spreadsheet much faster.
>
> To do this go to the Windows icon in the top left of the screen and click on
> Excel Options. Then choose the Formulas button and under Calculation Options
> choose the Manual radio button. Click OK.
>
> Then your spreadsheet will only calculate when you hit F9 or close/save the
> spreadsheet.
>
> "dcw13" wrote:
>
> > small worksheet. each time i enter a number in a cell i get the active
> > circle showing. i move to another cell but quite a delay time before freed
> > up for next entry. why?
From: ozgrid.com on 7 May 2010 22:18
I wouldn't use manual calculations as it's a false reading waiting to
happen. Besides, if you need manual calculations you have a design flaw.
http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm



--
Regards
Dave Hawley
www.ozgrid.com
"RD" <RD(a)discussions.microsoft.com> wrote in message
news:4C355966-35FE-4EBD-82BE-3AADF9733D32(a)microsoft.com...
> You have automatic Calculation on. By turning this off you will be able to
> update you spreadsheet much faster.
>
> To do this go to the Windows icon in the top left of the screen and click
> on
> Excel Options. Then choose the Formulas button and under Calculation
> Options
> choose the Manual radio button. Click OK.
>
> Then your spreadsheet will only calculate when you hit F9 or close/save
> the
> spreadsheet.
>
> "dcw13" wrote:
>
>> small worksheet. each time i enter a number in a cell i get the active
>> circle showing. i move to another cell but quite a delay time before
>> freed
>> up for next entry. why?

 | 
Pages: 1
Prev: Comment in every 11th row
Next: what is ^ in a formula for