I have built a financial model. Basically, I have project templates that
roll-up into a consolidated statement. To consolidate these projects, I use
the sum() formula. Here's an example of the formula:

=+SUM('EXISTING PROJ BEGIN:<<EXISTING PROJ END'!C57)

And by circular, since its a financial model, there is some circularity by
its nature. For example, interest expense is based on the loan balance,
which is determined by how much cash the business needs, which is partly
determined by interest expense.


"Niek Otten" wrote:

Please give more details about the layout of your workbook and the formulas used. Since "natural" circular is not that common, you
might explain what it's about in your case.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"adam" wrote in message ...
|I am having a problem with an excel model that I created. It has to be
| circular by nature, so I have turned calculations off and have to F9 whenever
| I want the model's formulas updated.
|
| The problem that I'm having is that I have pages that sum up values from
| multiple worksheets and these sum formulas are not updating when I make a
| change to the pages that the summary pages reference. I do not have any
| macros in the sheet. Does anyone know how to fix this?