Thread: Table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean[_8_] Dean[_8_] is offline
external usenet poster
 
Posts: 407
Default Table

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