pivot table 2007 formatting does not stay when refreshing

S

sanmos

Hi,

In the file, I have multiple tabs each having its own pivot table. When I
have to refresh one of the tabs, the formatting changes on all the other
tabs changes as well, most importantly the cells that have zero, I have
formatted this to hypens. These cells always goes back to zero's. Very
frustrating! I checked the box that says preserves formatting but it seems
that the formatting is not preserved. What is included in formatting?

Can someone explain why this is happening.

Thanks
 

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

Dealing with a Pivot Table (when I don't want to) 0
Preserve formatting of Pivot table template 0
Excel 2003 Pivot Table Formatting won't stay 0
grouping multiple tables Excel 2007 3
Pivot Table loses formatting after refresh? 0
Pivot Table - Changes 5
Pivot Table Formatting 4
Conditional Formatting - not working 0

Top