Microsoft Tech Community is in Read Only mode.  Please enjoy browsing our content while we complete our platform upgrade.

Forum Discussion

Kapil George's avatar
Kapil George
Copper Contributor
Sep 20, 2017

Modifying PivotTable Styles to include grouped gridlines

I need the old style Pivottable formatting as explained in the below url but when I apply a custom pivot table style to it the grouped gridlines disappear so is it possible to have the best of both worlds.

http://blog.contextures.com/archives/2010/05/14/pivot-table-formatting-old-style/

 

This is what I did

  • Create a pivot table with multiple row headings
  • Set the Pivot table layout to Tabular
  • If you set the Pivot Table Style to NONE, the gridlines show up very nicely. but there isn’t any color.
  • As soon as you pick another style (with color), the gridlines disappear.
  • I tried modifying the colorful style to include gridlines but we can’t figure out which Pivot element needs the gridline settings. We’ve tried all combinations but to no avail.
  • The closest we got was to add Inside and outside gridlines to the Whole table and then Outside gridlines to the Row Subheadings. But that didn’t work.

It would be nice to just modify the "None" style or at least copy the "none" style which has the gridline format we want but those options aren't available.

 

Resources