+ Reply to Thread
Results 1 to 5 of 5

Preserving pivot table formats. Preserve formatting checked but...

  1. #1
    Registered User
    Join Date
    11-14-2008
    Location
    Brooklyn, NY, USA
    Posts
    53

    Question Preserving pivot table formats. Preserve formatting checked but...

    Hi All,
    I'm having a devil of a time trying to preserve the formatting on a pivot table that I made in Excel 2003. As near as I can tell, I've done the appropriate things --- check the preserve formatting box, uncheck autoformat --- but my formatting is not preserved when I pivot.

    Adding to the mystery is the fact that some formatting is preserved but not all. I'm guessing either I'm missing something obvious or this is just an unruly, rogue pivot table that refuses to be formatted.

    Any insight would be tremendously appreciated. I've attached the workbook.

    Cheers,
    Tim
    Attached Files Attached Files
    Last edited by judasdac; 09-01-2009 at 11:29 AM.

  2. #2
    Registered User
    Join Date
    08-28-2009
    Location
    Wichita, KS
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Preserving pivot table formats. Preserve formatting checked but...

    I believe it is a bug.
    See: support.microsoft.com/kb/886176
    I had a similar problem with Pivot Chart Formatting.
    Somebody suggested a fix in the registry, I think a macro to reformat is safer.

  3. #3
    Registered User
    Join Date
    11-14-2008
    Location
    Brooklyn, NY, USA
    Posts
    53

    Re: Preserving pivot table formats. Preserve formatting checked but...

    Thanks! That explains it

  4. #4
    Registered User
    Join Date
    07-09-2008
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    91

    Re: Preserving pivot table formats. Preserve formatting checked but...

    have the same question... wondering if there is a workaround?

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,602

    Re: Preserving pivot table formats. Preserve formatting checked but...

    3 year old thread: rule #2
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1