+ Reply to Thread
Results 1 to 2 of 2

Pivot Table not Retaining Formatting

Hybrid View

  1. #1
    Registered User
    Join Date
    11-20-2006
    Posts
    40

    Pivot Table not Retaining Formatting

    I have built a Pivot Table and am having a hard time getting it to retain my standard formatting after I refresh.

    I have selected "Preserve Formatting" under Pivot Table Options.

    The table is holding the formatting on the body - but not for the Subtotals.
    For example:
    Down the Left side I have Products, in the body I have the sum of volume.
    The volume retains the formatting, but where it says "ETHANE TOTAL", it will not retain this formatting.

    I appreciate any help you may have.

  2. #2
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363
    Have a look at this example
    http://www.lacher.com/examples/lacher30.htm
    Denis

    Please always attach the sample workbook without sensitive information when asking for help

    To add a module
    Press Alt + F11 (this is the Visual Basic Environment)
    Insert Menu, select Module
    Past code there
    Close Visual Basic Environment (X)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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