![]() |
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 |
All times are GMT +1. The time now is 07:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com