Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Thank you so much!!!
Excel on-line, Pivot Table, Office Scripts
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I'm new to Excel on-line. I'm writing an Office Scripts and want to remove the entire Data Hierarchy before I add back the ones the users are requesting from a dropdown. I cannot figure out how to remove all of the existing ones. I found this: removeDataHierarchy(DataPivotHierarchy: DataPivotHierarchy): void; but I need a sample of code to figure it out. Can anyone help me with this?
Thank you
Microsoft 365 and Office | Excel | For business | Other
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
2 answers
Sort by: Most helpful
-
Anonymous
2023-01-25T16:30:42+00:00 -
Anonymous
2023-01-25T02:04:47+00:00 Dear Jenny,
Good day! Thank you for posting to Microsoft Community.
As per your description, it seems that you are trying to use Office scripts to remove the entire Data Hierarchy in Excel Online.
If my understanding is right, we've found a related article in **** GitHub **** for your reference.
If the issue still persists, considering that we mainly focus on Office general and build-in queries, for Office script related queries we have a dedicated channel Microsoft Q&A Community.
For you to be assisted properly, we sincerely recommend you go to that community and post a new thread. You may use "office development" tag when asking a question as shown below.
Members and engineers over there are proficient in the knowledge of Office scripts queries. They will focus on the specific situation on your side and share suggestions for you.
Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!
Sincerely,
Rhoda | Microsoft Community Moderator