Pivot Table Formatting

J

Joanne R.

I would like to customize the formatting of the pivot table I have created.
Add colors, grid lines, etc. However, each time the data is refreshed, the
formatting disappears. I have tried all table options - Preserve Formatting,
Autoformatting, Save Data with Table Layout, even the Enable Selection in the
Pivot Table toolbar. Each time, I just add simple gridline, hit refresh, and
they disappear. Is there a majic combination of these options I need to use?

Thanks in advance for your help! This site has truly been a source of great
information!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Consolidation Table from Different Excel Tabs with Different Format 1
Retain pivot table formatting after refreshing data 0
Pivot table report invalid 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
When refreshed, some Pivot Table columns retain formatting, some d 0
Pivot Table Formatting 0
Pivot Table formating 2

Top