Why do I have a permanent Calculate message in the Status Bar?

Hi

Have a Calculate in the Status bar permanently which is causing the workbook
to recalculate the entire workbook with every change made even if not
connected to other cells.

On the menu -- Goto Tools==> Options ==> Calculation (tab)

Click on the "Automatic" Button and click ok

See if this works.

"Andre" wrote:

> Hi
>
> Have a Calculate in the Status bar permanently which is causing the workbook
> to recalculate the entire workbook with every change made even if not
> connected to other cells.

Have tried that, I can set the calculation to manual which temporarily solves
the problem, however I need to write a macro function which utilises
goalseek, when that is activated every itteration takes about 10 seconds
which makes the VB function take over an hour to run, only complicated thing
in the spreadsheet is a pivot table with formulas refering to a named range
which looks at the table.

Any suggestions? Thinking of phoning Microsoft as the MCSE people we know
cant figure it either?


"Andre" wrote:

> Hi
>
> Have a Calculate in the Status bar permanently which is causing the workbook
> to recalculate the entire workbook with every change made even if not
> connected to other cells.

Hi

I'd name it 'bad formula use'. Probably you have a lot of volatile
functions/formulas, which mostly refer to wide range of cells. And for full
joy you use iterations too, do you? :-))). Best advice, I think, will be to
redesign all from scrap.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"Andre" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> Have a Calculate in the Status bar permanently which is causing the
> workbook
> to recalculate the entire workbook with every change made even if not
> connected to other cells.

"Bad Formula Use" lol, I do refer to named ranges which could be determined
wide. However only in the form of a v lookup. It just so happens that there
are nested ifs, lookups and iserrors, however this spreadsheet I am building
is by far less complicated than others, if I could just find what triggers
the calculate in the status bar - which I might add is damn near impossible
to find on help! then I could fix it.

Anyone know a MOS person with Financial spreadsheet building experiance.

"Andre" wrote:

> Hi
>
> Have a Calculate in the Status bar permanently which is causing the workbook
> to recalculate the entire workbook with every change made even if not
> connected to other cells.

There are several possible reasons:
- see http://www.decisionmodels.com/calcsecretsf.htm

regards

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Andre" <[email protected]> wrote in message
news:[email protected]...
> "Bad Formula Use" lol, I do refer to named ranges which could be
> determined
> wide. However only in the form of a v lookup. It just so happens that
> there
> are nested ifs, lookups and iserrors, however this spreadsheet I am
> building
> is by far less complicated than others, if I could just find what triggers
> the calculate in the status bar - which I might add is damn near
> impossible
> to find on help! then I could fix it.
>
> Anyone know a MOS person with Financial spreadsheet building experiance.
>
> "Andre" wrote:
>
>> Hi
>>
>> Have a Calculate in the Status bar permanently which is causing the
>> workbook
>> to recalculate the entire workbook with every change made even if not
>> connected to other cells.

Could there be a circular reference somewhere ?

Best wishes Harald

"Andre" <[email protected]> skrev i melding
news:[email protected]...
> Hi
>
> Have a Calculate in the Status bar permanently which is causing the
workbook
> to recalculate the entire workbook with every change made even if not
> connected to other cells.

Thanks Charles

Fixed it now!

"Andre" wrote:

> Hi
>
> Have a Calculate in the Status bar permanently which is causing the workbook
> to recalculate the entire workbook with every change made even if not
> connected to other cells.

And the problem / solution was ... ?

"Andre" <[email protected]> skrev i melding
news:[email protected]...
> Thanks Charles
>
> Fixed it now!
>
> "Andre" wrote:
>
> > Hi
> >
> > Have a Calculate in the Status bar permanently which is causing the
workbook
> > to recalculate the entire workbook with every change made even if not
> > connected to other cells.

And the problem / solution was ... ?

"Andre" <[email protected]> skrev i melding
news:[email protected]...
> Thanks Charles
>
> Fixed it now!
>
> "Andre" wrote:
>
> > Hi
> >
> > Have a Calculate in the Status bar permanently which is causing the
workbook
> > to recalculate the entire workbook with every change made even if not
> > connected to other cells.