• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Loss of Formatting on Refreshing Pivot Table

K

Kwesmc

New Member
When I refresh my pivot table, I lose some of the formatting. I've tried several fixes including "Preserve cell formatting on update". It is probably something stupid I'm missing, but I've run out of things to try.
Can someone please help with this issue. I can provide file if needed.

I lose the dark blue format as it turns to light blue. I have attached a screenshot. I can provide the file if need be.
Thanks,
Ken Mc94604-607c8a92e80965c19b7fec6db53bc6d3.jpg
 

Kwesmc​

Setting to Preserve Cell Formatting
  1. Right-click a cell in the pivot table, and click PivotTable Options.
  2. On the Layout & Format tab, in the Format options, remove the check mark from Autofit Column Widths On Update. ...
  3. Add a check mark to Preserve Cell Formatting on Update.
  4. Click OK.
 

Kwesmc​

... then as You wrote I can provide the file if need be.
  • When drafting a question, try and lay out the question in a clear and concise way.
  • Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
  • Don't leave out information more info is better
  • For the best/fastest results, Upload a Sample File
 
You must log in or register to reply here.
Back
Top