Calculation Loop

**ronaldk** · 09-16-2009, 11:51 AM

I have written a financial needs analysis program with 20 userforms for inputs, but most calculations done on the worksheets itself. The program however continues to go into a calculation loop and it has been impossible for me to determine what causes this.

What are the main reason normally associated to such a continuous calculation.
Maybe that will help me find the problem.
Regards

**Andy Pope** · 09-16-2009, 11:55 AM

Is it a calculation loop or a code loop?

Do you have worksheet event code. Changing a cell whilst in the change event will cause the event to fire again unless you have disabled events.

Do you have circular references on the sheet?

**Palmetto** · 09-16-2009, 11:56 AM

This could best be answered by allowing others to examine your code/workbook. Can you post a copy (scrubbed of sensitive data)?

At least post the code for when to begin the calculations. Sounds like it could be related to incorrect looping.

**ronaldk** · 09-19-2009, 08:20 AM

Sorry it took so long to reply. (Out of town). Most events focus on the forms. There are no events linked to the worksheets. There are also no circular calculations.
One change does however impact a significant amount of other calculations, eg an increase in the value of an asset changes 4 tax calcs, 3 costs calcs, a liquidity calc & 12 needs calcs.
I have now turned calculation on manual and it only activates if a report is viewed or printed, I am moving most code out of the forms to modules and will see if this works.
If it doesn't I'll pull an Arnie...
I'll be Back