Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
385
Views
Topic starter
Good morning.
I have a pivot table with 3 wrap text columns. In the PivotTable Options, I have unchecked Autofit column widths on update and only have checked Preserve cell formatting on update. When I refresh the pivot table, the columns with wrap text revert back. How can I preserve the wrap text columns on refresh?
Thank you,
Alicia
Posted : 17/06/2022 8:34 am
Hi Alicia,
If the settings you've already selected aren't working then I'd say you can't. I'm not aware of any other setting you could apply that will force the PivotTable to respect the wrap text setting, sorry.
Mynda
Posted : 17/06/2022 7:16 pm
