Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,712 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I would like to change the title for a Pivot Table DataHierarchy field. I cannot find any documentation. Specifically, I'd like to change the field name from "Sum of aDate" to "aDate" I'm using Office Script/Java Script. I tried recording the task but the script uses hard coded reference
/*function main(workbook: ExcelScript.Workbook) {
let selectedSheet = workbook.getActiveWorksheet();
// Set range H9 on selectedSheet
selectedSheet.getRange("H9").setValue(" 25Jul22");
}*/
thank you
Jenny