Weird calc behavior - Guru challenge?

[JuergenL]

Excel does not calculates consistent based on the number of open worksheets.

In a nutshell:
Two cells on a worksheet are input into a macro. Macro calculates as soon as only one cell is changed (using the unchanged value in the second cell). Second cell in the workbook changes after the macro finishes. End of calc.
I get the correct value after pressing F9.

Win 2000 Pro, 512 MB, Excel 2003 SP2

There is of course more, but this happens after a certain amount of worksheets are open.
Anybody out there willing to discuss this with me? I am at my wits end.

Juergen

[Charles Williams]

hi Juergen,

Not sure I understand what you are doing or what is going wrong:

You have a Sub which is called when one cell is changed (How is it called?)
The Sub runs and changes another cell (I assume inserts a value into the
cell).

Something does not work (what does not work?) until you press F9

Do you have a circular process?

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"JuergenL" <JuergenL.25pbcb_1144089302.707@excelforum-nospam.com> wrote in
message news:JuergenL.25pbcb_1144089302.707@excelforum-nospam.com...
>
> Excel does not calculates consistent based on the number of open
> worksheets.
>
> In a nutshell:
> Two cells on a worksheet are input into a macro. Macro calculates as
> soon as only one cell is changed (using the unchanged value in the
> second cell). Second cell in the workbook changes after the macro
> finishes. End of calc.
> I get the correct value after pressing F9.
>
> Win 2000 Pro, 512 MB, Excel 2003 SP2
>
> There is of course more, but this happens after a certain amount of
> worksheets are open.
> Anybody out there willing to discuss this with me? I am at my wits
> end.
>
> Juergen
>
>
> --
> JuergenL
> ------------------------------------------------------------------------
> JuergenL's Profile:
> http://www.excelforum.com/member.php...o&userid=21816
> View this thread: http://www.excelforum.com/showthread...hreadid=529313
>