"Old" data in pivot tables

[Mike Lewis]

I have created an application that uses pivot tables. In
the design phase I put "bogus" records into the database
that is the source for the pivot table.
Now that I have erased all of the bogus data and
added "real" records. The pivot table still "remembers"
the bogus data. The old records do not show up in
the "data section" of the "Data" section, but do show up
in the drop down arrows for each field and make it
difficult to show or hide the desired "real" records.

I am using Release 9.0

Thanks

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlPivot04.html

 

[Max]

Try Debra Dalgleish's notes at:

http://www.contextures.com/xlPivot04.html

 

[Mike]

Thanks ! It worked perfectly!

-----Original Message-----
Hi
have a look at
http://www.contextures.com/xlPivot04.html

--
Regards
Frank Kabel
Frankfurt, Germany



.