Conditional Formatting not holding in pivot table querying Access

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

Chuck W

Hi,
I have created a pivot table in Excel 2007 based on an Access query. I then
created some conditional formatting. My values in the pivot table are
percentages. I have red, green and yellow based on what the percentage is.
Everything is fine until I refresh the pivot table. The pivot table size
does not change (No new rows added). It wipes out all of the color coding
though. When I select a cell in my pivot table and select Conditional
Formatting, the rules are still there but there is not color. I originally
did this file in Excel 2003 and did not have this problem. Can someone help?
Thanks,
 
Hi Chuck

Right click on any cell within your PT>Table Options>Layout tab>ensure that
Preserve cell formatting on update is checked
 
Roger,
The preserve cell formatting is already checked. I googled the issue and
several others have the same problem. Basically, they had to write a bunch
of VBA code to preserve the formatting. Apparently, when the pivot table is
created in a previous version and then upgraded to 2007, the 2007 does not
hold the formatting.
 
Back
Top