Prev: 12 digits - auto change
Next: Excel File Mirror/Clone
From: sanmos on 10 May 2010 14:20 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
|
Pages: 1 Prev: 12 digits - auto change Next: Excel File Mirror/Clone |