Pivot tables and deleted data ... HELP PLEASE

[Jes]

I acquired an excel document from a client who wish me to use it for an
upcoming project. I deleted the data from the main page that all the pivot
tables feed from (which you would think would make all data or memory of it
completely disappear). However the information that was on the main page is
hanging around in the drop downs on the pages that use the pivot tables even
though it is no longer showing anywhere else (I did refresh the data).
Selecting it from the drop down does nothing (because there's no data
attached) however my client is bothered by the mere fact that the old data is
being remembered at all so I need to get rid of it.

If any of what I've said makes sense at all ...what do I need to do to be
completely rid of it (short of rewriting the entire document which is rather
extensive).

Thanks

Jes

 

[Debra Dalgleish]

There are instructions here for clearing old items from a pivot table:

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

 

[Jes]

Thank you! That's exactly what I need. Now to figure out where to run the
program.

 

[Debra Dalgleish]

You're welcome! There are instructions here for copying the code to your
workbook, and running the macro.

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

 

[Jes]

Thank you Debra ... I figured it out. It has been awhile since I fiddled
with Excel and Macros but it's somewhat like riding a bicycle LOL.

Jes