+ Reply to Thread
Results 1 to 3 of 3

Row Height Changes When Pivot Table is Refreshed

  1. #1
    Forum Contributor
    Join Date
    10-25-2010
    Location
    Phoenix, Arizona, USA
    MS-Off Ver
    O365
    Posts
    201

    Unhappy Row Height Changes When Pivot Table is Refreshed


    I am new to pivot tables, just hasn't been one of my needs before.

    I have a pivot table that I adjusted the HEADINGS row to allow displaying long Headings in a wrapped text format.

    When I refresh the pivot table, the HEADINGS row height reverts to the default row height. The text in the heading row also reverts back to default setting (Arial 10).

    Is there any way to maintain the row height and font size that I have to customize after each time I "refresh" my pivot table?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Row Height Changes When Pivot Table is Refreshed

    try right-clicking in the table and going into PT options. under layout and formatting, make sure that "preserve formatting on update" is checked
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    10-25-2010
    Location
    Phoenix, Arizona, USA
    MS-Off Ver
    O365
    Posts
    201

    Re: Row Height Changes When Pivot Table is Refreshed

    I have gone to the PT options and have confirmed "preserve formatting on update" was checked.

    Any other ideas/suggestions?

+ 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