Calculation loop problem

[brad]

I have a 45 meg workbook that I have set to manual calc due to the
minutes it takes to calculate. Just recently when ever the workboo
calcs using F9 when it finishs it goes back to saying it needs a cal
done again. I hit F9 again and it starts calculating for 5 minute
again.

I have also noticed certain cells not calculating using F9. Any idea
how to identify what appears to be a loop. I don't use subtotaling an
the version is 2003

 

[Charles Williams]

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

the most likely is more than 655536 dependencies.


regardsCharles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

 

[brad]

Charles thanks for that I reco your right. Have you used fast excel, i
it worth purchasing.

Brad

 

[David McRitchie]

Hi Brad,
Charles is the creator of "Fast Excel" and "Computer Decisions"
is his web page. Would think that was obvious from his
signature line at bottom of his post, but you can start from here:
http://www.decisionmodels.com/aboutus.htm
and look at products.

655536 dependencies was a typo, the number is 65,536 as noted
within his web page reference.

 

[Charles Williams]

so of course FastExcel is worth purchasing!

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

Hi Brad,
Charles is the creator of "Fast Excel" and "Computer Decisions"
is his web page. Would think that was obvious from his
signature line at bottom of his post, but you can start from here:
http://www.decisionmodels.com/aboutus.htm
and look at products.

655536 dependencies was a typo, the number is 65,536 as noted
within his web page reference.