If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|