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.