Hello,
I would like to remove "Group Fields" I had created in some Pivot Tables.
When some field values are grouped in a PT, Excel creates an "Group Field" for this purpose.
These "group fields" become members of the "Pivot table fields list".
Now that I created these grouping values in my database, I would like to remove these "group fields" from my pivot tables.
My motivation is performance.
I have more than 50 PT, all based on large datasets.
I keep them together in one big excel file for convenience.
I have the feeling that the "group field" are deteriorating sometimes the performance.
Today, Excel has been crashing several time when saving the file, therefore, I want to get it slimmer.
Would you know how I could remove the "group fields", at least to check if it works better.
Thanks
I would like to remove "Group Fields" I had created in some Pivot Tables.
When some field values are grouped in a PT, Excel creates an "Group Field" for this purpose.
These "group fields" become members of the "Pivot table fields list".
Now that I created these grouping values in my database, I would like to remove these "group fields" from my pivot tables.
My motivation is performance.
I have more than 50 PT, all based on large datasets.
I keep them together in one big excel file for convenience.
I have the feeling that the "group field" are deteriorating sometimes the performance.
Today, Excel has been crashing several time when saving the file, therefore, I want to get it slimmer.
Would you know how I could remove the "group fields", at least to check if it works better.
Thanks