Format a pivot
I followed the instruction below and set up a pivot table/chart.
All other formats are untouched however the "value" in the chart is lost
every time refreshed. Is there any way to protect it as well?
Thanks!
"Roger Govier" wrote:
Hi
Right click on PTTable Optionsdeselect Autoformat
--
Regards
Roger Govier
"officegirl" wrote in message
...
After I format my pivot table every time I change the info in it , it
turns
back to the original format, not just when I update it but when I am
looking
for a specific combination of info
|