3 Pivot Tables
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?
--
Toby Erkson
Oregon, USA
Excel 2002 in Windows XP
"Todd Huttenstine"
wrote in message
...
Hey guys
Before I ask this question I know Im probably going to
get
the answer that I need more memory but I think there has
to be another way...
I have 3 pivot tables on 1 worksheet. They all work
perfectly. Heres the problem. Lets say I change a
column
field value from the drop down on any pivot table, then
I
change another page field value from the drop down on a
second pivot table, and then I change another page field
value from the drop down on the 3rd pivot table. It
does
not matter in which order of pivot tables I do this
with,
I will get an error on the 3rd pivot table. It
says "Not
enough memory" and "continue with undo"
I believe this can be corrected if I could somehow clear
the memory in use. Maybe clear the memory after each
pivot table is calculated??? What is a code to clear
memory or is there anything else that will correct or
help
this?
Thank you
Todd Htutenstine
.
|