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<attarkon.ee )


"Andre" wrote in message
...
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" wrote in message
...
"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" skrev i melding
...
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" skrev i melding
...
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.

I wish he would have put in what fixed it. I have a user with exactly the
same problem! I still don't know what to do to fix it.
--
Brenda


"Harald Staff" wrote:

And the problem / solution was ... ?

"Andre" skrev i melding
...
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.

Hello Brenda
May be Tools, Options and turn Calculation mode to Automatic in the
Calculation tab?

HTH
Cordially
Pascal

"Brenda from Michigan" a
écrit dans le message de news:
...
I wish he would have put in what fixed it. I have a user with exactly the
same problem! I still don't know what to do to fix it.
--
Brenda


"Harald Staff" wrote:

And the problem / solution was ... ?

"Andre" skrev i melding
...
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.

No, that doesn't help. I am following up with the link sent by Charles
Williams.
--
Brenda


"papou" wrote:

Hello Brenda
May be Tools, Options and turn Calculation mode to Automatic in the
Calculation tab?

HTH
Cordially
Pascal

"Brenda from Michigan" a
écrit dans le message de news:
...
I wish he would have put in what fixed it. I have a user with exactly the
same problem! I still don't know what to do to fix it.
--
Brenda


"Harald Staff" wrote:

And the problem / solution was ... ?

"Andre" skrev i melding
...
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.

Sorry Brenda
Don't know what the original post was and since yours shows as a new one..
But anyway try and check for Add-ins checked, uncheck one by one and close
and re-open Excel each time.
Also see files in the xlStart folder including PERSONAL.XLS.

HTH
Cordially
Pascal

"Brenda from Michigan" a
écrit dans le message de news:
...
No, that doesn't help. I am following up with the link sent by Charles
Williams.
--
Brenda


"papou" wrote:

Hello Brenda
May be Tools, Options and turn Calculation mode to Automatic in the
Calculation tab?

HTH
Cordially
Pascal

"Brenda from Michigan" a
écrit dans le message de news:
...
I wish he would have put in what fixed it. I have a user with exactly
the
same problem! I still don't know what to do to fix it.
--
Brenda


"Harald Staff" wrote:

And the problem / solution was ... ?

"Andre" skrev i melding
...
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.

The older posts have aged off my newsreader, but maybe...

http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References

Brenda from Michigan wrote:

I wish he would have put in what fixed it. I have a user with exactly the
same problem! I still don't know what to do to fix it.
--
Brenda

"Harald Staff" wrote:

And the problem / solution was ... ?

"Andre" skrev i melding
...
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.




--

Dave Peterson

There are several possible causes for this: some of them are easily fixable,
some are not.

see http://www.decisionmodels.com/calcsecretsf.htm for details

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"Brenda from Michigan" wrote
in message ...
I wish he would have put in what fixed it. I have a user with exactly the
same problem! I still don't know what to do to fix it.
--
Brenda


"Harald Staff" wrote:

And the problem / solution was ... ?

"Andre" skrev i melding
...
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.