Data Tables  
Author Message
kgoodman





PostPosted: Top

Excel Programming >> Data Tables

I have created some data tables and keep enlarging them, by adding more
columns to the right and more rows down further.

I believe that, each time I expand these 5 basic tables, all I have done is
enlarge the area I select and then hit data, then table. However, now, when
it recomputes, it seems like the tables take much longer and that I don't
see my tables being updated until, at the bottom left, I see "Table 16" thru
20 (not 1 through 5 anymore), even though I only think I have 5 of them.

I therefore suspect that, when I enlarge the area for a data table, I am
inadvertently leaving the smaller data table 'behind' it and, even though I
cannot see the results anymore, the old data table and its results are still
'lurking in the shadows', if you will, causing the file to compute the old
obsolete tables also.

If each new data table was created 'on top of' the old smaller one, can
someone tell me how to delete the older obsolete ones, but not the most
recent one that appears?

Thank you very much.

Dean A

Excel95