I am trying to preserve the color scheme of a pivot table. Every time I refresh the table it resets the colors.
I have "Preserve cell formatting on update" checked but it doesn't seem to be working.
Any ideas on how to solve this?
Thanks
I am trying to preserve the color scheme of a pivot table. Every time I refresh the table it resets the colors.
I have "Preserve cell formatting on update" checked but it doesn't seem to be working.
Any ideas on how to solve this?
Thanks
Try, Table Tools > Properties > Preserve cell formatting
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks