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?

Wed, 30 Jan 2008 07:43:02 -0800 from adam
:
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?

Excel 2003 help says that F9 recalculates all worksheets in all open
workbooks. Where are these other worksheets?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

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?

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?

In the same workbook

"Stan Brown" wrote:

Wed, 30 Jan 2008 07:43:02 -0800 from adam
:
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?

Excel 2003 help says that F9 recalculates all worksheets in all open
workbooks. Where are these other worksheets?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

You could use SHIFT-F9, which will calculate the active sheet only.

But even if the sheet is "circular", you can still have Automatic calculation. Or does it take too much time?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"adam" wrote in message ...
|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?
|
|
|

It won't calculate unless I set a limit on the number of itirations.

"Niek Otten" wrote:

You could use SHIFT-F9, which will calculate the active sheet only.

But even if the sheet is "circular", you can still have Automatic calculation. Or does it take too much time?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"adam" wrote in message ...
|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?
|
|
|

Adam,

I don't understand the problem, I'm afraid.

If you have and need circular references, check Iterations in the ToolsOptionsCalculation tab.
Set Maximum iterations to whatever you think is useful. In financial workbooks I find that generally a solution will be found in
5-7 iterations, but you can leave it at 100 too, because Excel will stop iterating when it finds a solution with the required
accuracy.
What do you mean if you say "It won't calculate unless I set a limit on the number of iterations"? What happens? What do you see?


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"adam" wrote in message ...
| It won't calculate unless I set a limit on the number of itirations.
|
| "Niek Otten" wrote:
|
| You could use SHIFT-F9, which will calculate the active sheet only.
|
| But even if the sheet is "circular", you can still have Automatic calculation. Or does it take too much time?
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
| "adam" wrote in message ...
| |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?
| |
| |
| |
|
|
|