Hello.
I made an office script that is building a pivot table. I want to change the value field settings within my pivot table. The "action record" feature won't let me record this step. This step is to convert the values from a SUM to an AVERAGE. When using the record action to record my manual steps for the script. It say's " Action not yet recordable". How can I input this as an action in my script? Is there a way to manually code this? Thank you.


Report
All responses (
Answers (