need to clear data references in pivot table report

M

Mikeeusa

I have a sheet that records registration data. It is supported by different
Pivot Table reports. The data in the main sheet changes twice a year and I
need to find a way to clear the references that the reports use (as in 'show
all', 'blank', etc.). I can clear the data from the main sheet, but the
reports hold the data references. It is not affecting the reports
functioning, it is just creating a HUGE reference list.
 
M

Mikeeusa

Thank You!! It worked except for one tough field which I can live with. It is
astonishing to me how little MS helps with Pivot Tables in general. Thanks
again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Possible to Combine reports to's to a single box? 0
pivot table missing rows? 0
Cross-reference Insert Default Change 0
Pivot table report invalid 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Top