How can I enable circular calculation permanently?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scube-Ron - 27 Jan 2005 00:49 GMT

I have spreadsheets that depend on circular calculations to compute final
result. Excel forces me to set the iteration and enable circular each time I
open the file. I want it to accept circular as the default as other
spreadsheet programs have done. Does anyone know how to do this in Excel
2000?

Reply to this Message

Dave Peterson - 27 Jan 2005 01:22 GMT

Record a macro when you set the calculation the way you like.

Then rename that recorded macro:
Auto_Open

It'll run each time you open that workbook.

Excel determines the calculation mode from the first workbook that you open in
that session--so it could be an ongoing fight without a macro.

> I have spreadsheets that depend on circular calculations to compute final
> result. Excel forces me to set the iteration and enable circular each time I
> open the file. I want it to accept circular as the default as other
> spreadsheet programs have done. Does anyone know how to do this in Excel
> 2000?

Signature

Dave Peterson

Reply to this Message