pivot table 2007 formatting does not stay when refreshing
 

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