reset all pivot field properties

E

eggman

I'm hoping there is an efficient way to reset all properties for a pivot
field. The pivot table pulls from a local Access db, so end users will not
be able to refresh. The problem that I'm hitting is that if items are
deselected or sums/averages/counts are changed, those changes are retained
even when the field is removed from the pivot table and then put back in.
Reseting each property individually is getting inefficient.

Thanks in advance
 

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

Top