You could post your workbook to a site like www.savefile.com, however there is
no guarantee that anyone will actually look at it. If you do post a workbook,
keep it as small as possible.


rock wrote:
Is there a way to share a stripped down version of the file?

I'll try to get the formulas copied to this message forum

rocknroll


"Glenn" wrote:


Maybe you could share the formula with the group?


rock wrote:
I am building a forestry growth and harvest model that forecasts out twenty
years ahead. I need to be able to change assumptions such as beginning
volume per acre and annual harvest volume. I have a circular reference and
have turned on iteration to allow recalculation. However, I get "Divides by
Zero Error" (#DIV/0!) beginning a year ten when I change an assumption.
Changing the number of maximum iterations and maximum change does not appear
to ahve any impact. If I recopy the formula over the error message, #DIV/0!,
when the cells recalculate with a value. What options do I have to change
assumptions without errors?