| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Global" change Pivot Value field settings
Other than a macro, is there a simple way to change the value field settings
for an entire pivot table at once? I want to flip the report from sum to average to count across all 40 Value columns - it's a little laborious a column at a time. -- Mike Watkins |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change default settings of "Save external links values" | Excel Discussion (Misc queries) | |||
| Pivot tables - how do I change default from "count of" to "sum of" | Excel Worksheet Functions | |||
| How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
Threaded Mode
