Maintain format of pivot after refresh

B

Bonnie

how do I keep the number formatting for my pivots after I refresh them?
I tried just going to table options and selecting "preserve formatting" and
unselecting "autoformat table" but this doesn't maintain the number
formatting inside the pivot.
 

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

Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Change external data source for multiple worksheets 4
Dealing with a Pivot Table (when I don't want to) 0
Address Format changed after Migration 0
Excel does not accept text format! 0
Preserve Formatting for Pivot table cross 'Refresh Data !' 0
Print (physical or pdf) not respecting format of source document 0

Top