Format a pivot

  • Thread starter Thread starter officegirl
  • Start date Start date
O

officegirl

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
 
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!
 
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, which suggests recording a
macro as you apply the formatting:

Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/?id=215904
 
You must log in or register to reply here.

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

Pivot Table - Changes 5
Pivot Table date format 1
Field Formatting in Pivot Tables 1
Pivot Table - Currency Format 1
Save graph formatting 4
date filter in a pivot table 1
Pivot table formating 1
Pivot Table - NUMBER FORMAT option does not appear in field settin 3

Back
Top