Preserving Pivot Table Formatting

B

Bucko

Hi All,

I've noticed a few threads related to the topic of preservingi table
formats after a refresh, but after trying all the suggestions (along
with Contexture's tip on the issue), many of my tables still loose
their formatting after the table is refreshed. Simple formatting too
- like horizontal and verticle lines.

What I've also noticed, though, is that if you select each cell, one
at a time, and format the cell, there's a better chance that
formatting will stick. But its not 100%.

Does anyone know "why" there is formatting loss upon refresh? I'm
using Excel 2003.
 
J

Jake

If you turn off the "AutoFormat" option in the table options you
should be fine; autoformatting standardizes the table format
regardless (for the most part) of previous changes.
 
B

Bucko

Thanks Jake,

Yea, I have the AutoFormat disabled, Preserve Formatting turned on,
all that. The formatting retention problem seems to be a common one -
probably linked to the way pivots are treated in Excel (behind the
scenes). Sure wish MS would put out a patch or something.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting not holding in pivot table querying Access 2
Formatting a pivot table 6
Pivot table loss formatting after update 3
Pivot table formatting removed/lost/reverted upon refresh 1
Pivot Table formatting 2
pivot table formatting issues 2
Conditional Formatting in a pivot table 2
Pivot Table loses formatting after refresh? 0

Top