none
how to keep cell format in pivot table RRS feed

  • Question

  • hello All,

    I have a pivot table in excel 2010 when ever i am setting specific format on pivot table its changing when i am doing the refresh every time. I tried with the option of "Preserve cell formatting on update" also but did not work its keep changed to old format.

    How i can able to keep my formatting on my pivot table because each time formatting tooks long time to do. Please help me for the solution.


    VinWin06

    Tuesday, September 16, 2014 5:47 AM

Answers

  • I have found the answer 

    formatting to the fields in the pivot table rather
    than the rows & columns in the worksheet. If you format a whole column that
    includes part of your pivot table, for example, the formatting will be lost
    when the pivot table is refreshed.

    To format a field in the pivot table, put the cursor right over the heading
    of the desired field, then slowly move the cursor upwards. Left-click when it
    changes to a downward-pointing arrow. All the data for that field will be
    selected. Now select Format >> Cells >> select your desired formatting >> OK.
    Formatting applied this way will persist when the pivot table is refreshed
    (such as when a new item is selected).


    VinWin06

    • Marked as answer by vinwin1985 Tuesday, September 16, 2014 7:59 AM
    Tuesday, September 16, 2014 7:58 AM

All replies

  • What kind of formatting are you doing? Just basic formatting? Normally this should work, but apply rou formatting on your pivot without any filters set.

    Maybey try conditional formatting on you pivot as an alternative?

    Tuesday, September 16, 2014 7:53 AM
  • I have found the answer 

    formatting to the fields in the pivot table rather
    than the rows & columns in the worksheet. If you format a whole column that
    includes part of your pivot table, for example, the formatting will be lost
    when the pivot table is refreshed.

    To format a field in the pivot table, put the cursor right over the heading
    of the desired field, then slowly move the cursor upwards. Left-click when it
    changes to a downward-pointing arrow. All the data for that field will be
    selected. Now select Format >> Cells >> select your desired formatting >> OK.
    Formatting applied this way will persist when the pivot table is refreshed
    (such as when a new item is selected).


    VinWin06

    • Marked as answer by vinwin1985 Tuesday, September 16, 2014 7:59 AM
    Tuesday, September 16, 2014 7:58 AM