Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reset all pivot field properties
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reset my format cell properties | Excel Programming | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
reset default field settings in pivotable reports | Excel Discussion (Misc queries) | |||
Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
Auto advance to next field -tab key AND option button to reset fie | Excel Programming |