Each time I refresh my pivot table (MS Office 365, Excel 2016), some (not all!) the columns with centred formatting reformat to their default status (i.e. left for alpha, right for numeric) and I have to reformat. It's only an inconvenience, but does anyone know how to preserve the formatting? Thanks.
Last edited by AlastairMc; 11-23-2017 at 08:46 AM. Reason: Left out bit of information
hi alastairmc, try uncheck "Autofit column widths on update" in the PivotTable Options
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
Many thanks, Alvin, but unfortunately that box was already unchecked. I tried checking and unchecking it again, but no joy.
interesting, could you have a sample file upload so that anyone here could take a look?
Hello,Originally Posted by AlastairMc
Enable the tick for "Preserve cell formatting on update" in Pivot table options?!
Regards,
Thangavel D
Appreciate the help? CLICK *
Unfortunately it's a confidential file so I can't really upload any part of it. I'll try to replicate it in another file, though that might take me a while. Thanks again for such a quick response.
Thanks, than_gold, but it's already enabled. At least with your and Alvin's advice, I don't feel as stupid as I did!
Oh..good to know. But without the sample data we won't be able to solve the issue. Since it's confidential data..these kind of possible ways only we give you based on your input.
Much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks