LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data validation and vlookup over 12 tables of data Joe W[_2_] Excel Discussion (Misc queries) 1 September 11th 09 02:49 AM
Removing Data Tables formed from importing data from Access Andrea Jones Excel Discussion (Misc queries) 0 April 10th 08 12:01 PM
DATA > TABLE -- 2 variable data tables? efarhat Excel Worksheet Functions 1 August 24th 05 10:35 PM
DATA > TABLE -- 2 variable data tables? efarhat Excel Discussion (Misc queries) 0 August 24th 05 07:29 PM
How to cause a pivot tables to not summarize data - just report the data Greybeard Excel Discussion (Misc queries) 0 July 27th 05 10:21 PM


All times are GMT +1. The time now is 10:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"