It's annoying the way the pivot chart destroys all your carefully chosen
formatting every time it refreshes.
Perhaps, just before you refresh, you could copy the formats to an empty
sheet, then copy them back again onto the pivot table after the refresh?
Perhaps the clever folk who know VBA could even arrange for a macro to
do it automatically?
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.