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