1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/OrganicMix3499
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#financial modeling with spreadsheets
#pivots
#Excel
#workbook
#source data
#Preserve cell formatting