New Pivots Not Acting Correctly
This is odd and I just can't figure it out. My existing pivots act just fine, the problem is with any newly created ones. I doesn't matter if it's in a new or existing workbook.
No matter what I do, all fields in Rows are centered (column fields too but I actually want those centered). Checking the Preserve cell formatting on update does nothing. Neither does checking/unchecking/left aligning cells/left aligning the fields...tried them in various different orders. Source data is all left aligned. Can't find anything in Excel options that looks like the culprit.
This just recently started and it's driving me crazy. Maybe it's a bug from a recent update? I may have to resort to copying and old pivot then changing the data source, instead of creating new ones.
Anyone else run across this?
[link] [comments]
Want to read more?
Check out the full article on the original site