Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data validation and vlookup over 12 tables of data | Excel Discussion (Misc queries) | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
DATA > TABLE -- 2 variable data tables? | Excel Worksheet Functions | |||
DATA > TABLE -- 2 variable data tables? | Excel Discussion (Misc queries) | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) |