Thread: 3 Pivot Tables
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Toby Erkson[_2_] Toby Erkson[_2_] is offline
external usenet poster
 
Location: Portland, Oregon
Posts: 26
Default 3 Pivot Tables

Did you create them each as a separate query, using the Pivot Table Wizard?
If so, I would recommend you select the first table (assuming it is the one
you created first) by right clicking anywhere within it, click Select, then
click Entire Table. Copy the selection using Ctrl C and paste (Ctrl V) it on
the same spread sheet, like below your #2 table (not on top of it!). Doing
the same thing, copy the FIRST table and paste it under your third table.
Now, you can fill in the fields in the 'new' tables so they match the fields
in the tables they are under. When done you can delete the 'old' #2 and #3
tables and move the 'new' tables in their place. This way if you have any
charts that point to these locations they won't get messed up.

Each table now only pulls -- and saves -- data from one source. This can
greatly reduce memory consumption and each table can still be individually
manipulated.
--
Toby Erkson
Oregon, USA
Excel 2002 in Windows XP

"Todd Huttenstine" wrote in message
...
They all pull from the same source
-----Original Message-----
Well, from the sound of it, you can simply continue it's

just that you won't
be able to Undo anything, that's all.

Do the three tables each pull from a different data

source or do they use the
same one?