In this file sent to me, I eliminated the obvious circular references
necessitating iterative solutions. I still note that, when I hit recalc, at
the bottom left it goes through "Table: 1" through "Table 9". If I have
only this file open, it does it in a second or so, and then says ready.

If I have another file open, one which is just a normal file, then it take a
long time (probably because the other file is so big), like one minute, to
go through Table 1 through Table 9. But, also when it seems to be done, the
bottom says "recalculate". It seems that, if I have another file open, it
can't recalc this Table stuff.

Does anyone know what this "Table: 1" type stuff is (is it some sort of data
table that, somehow, still requires manual recalc maybe?) and also why it
seems to NOT recalc if another benign file is open?

Thanks!
Dean

Probably arrays filled with the Data Table command.
In Extra Options Calculations these can be exempted from
autocalculation.

See excel Help on Data Tables.




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Dean wrote :

In this file sent to me, I eliminated the obvious circular references
necessitating iterative solutions. I still note that, when I hit
recalc, at the bottom left it goes through "Table: 1" through "Table
9". If I have only this file open, it does it in a second or so, and
then says ready.

If I have another file open, one which is just a normal file, then it
take a long time (probably because the other file is so big), like
one minute, to go through Table 1 through Table 9. But, also when it
seems to be done, the bottom says "recalculate". It seems that, if I
have another file open, it can't recalc this Table stuff.

Does anyone know what this "Table: 1" type stuff is (is it some sort
of data table that, somehow, still requires manual recalc maybe?) and
also why it seems to NOT recalc if another benign file is open?

Thanks!
Dean

Yes, I think you've got it. Why it seems to never finish calc'ing when
another large file is open, I'm not sure. But I guess, I'll just never open
another file when I'm working on this one.

Thanks!
D

"keepITcool" wrote in message
t.com...

Probably arrays filled with the Data Table command.
In Extra Options Calculations these can be exempted from
autocalculation.

See excel Help on Data Tables.




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Dean wrote :

In this file sent to me, I eliminated the obvious circular references
necessitating iterative solutions. I still note that, when I hit
recalc, at the bottom left it goes through "Table: 1" through "Table
9". If I have only this file open, it does it in a second or so, and
then says ready.

If I have another file open, one which is just a normal file, then it
take a long time (probably because the other file is so big), like
one minute, to go through Table 1 through Table 9. But, also when it
seems to be done, the bottom says "recalculate". It seems that, if I
have another file open, it can't recalc this Table stuff.

Does anyone know what this "Table: 1" type stuff is (is it some sort
of data table that, somehow, still requires manual recalc maybe?) and
also why it seems to NOT recalc if another benign file is open?

Thanks!
Dean