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.
