Table

[Dean]

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

 

[keepITcool]

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 :

 

[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