Forum Discussion
Excel Pivot Table Design Style no longer formats Grand Totals
Hi - I am wondering if the 9/28 update caused an issue with existing pivot tables. All my pivot tables in existing spreadsheets have lost the formatting of the Grand Totals and the Design Styles all ...
I just upgraded to office 365 and having the same issue.
The format on grand total is gone whether I refresh the old pivot or re-created my pivot
I found out it shows the old format if I choose the grand totals to "On for Rows and Columns"
But most of the times I only need to show grand totals for "Columns Only", temporarily to retain the format I do :
1. Choose the layouts as "On for Rows and Columns"
2. Copy and paste the grand totals row
3. Change the layouts as "Columns Only"
4. Copy the grand totals row on step 2 with format painter and paste it on the grand totals pivot
It is such a hassle, I hope microsoft fix this
The format on grand total is gone whether I refresh the old pivot or re-created my pivot
I found out it shows the old format if I choose the grand totals to "On for Rows and Columns"
But most of the times I only need to show grand totals for "Columns Only", temporarily to retain the format I do :
1. Choose the layouts as "On for Rows and Columns"
2. Copy and paste the grand totals row
3. Change the layouts as "Columns Only"
4. Copy the grand totals row on step 2 with format painter and paste it on the grand totals pivot
It is such a hassle, I hope microsoft fix this