+ Reply to Thread
Results 1 to 3 of 3

how to stop Expand Entire Field when Refresh pivot table

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    los angeles
    MS-Off Ver
    Excel 2010
    Posts
    2

    how to stop Expand Entire Field when Refresh pivot table

    When I do a Refresh of my pivot table, Excel also does Expand Entire Field, showing more detail than I want to start with. Can I prevent this somehow?
    Excel 2010.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: how to stop Expand Entire Field when Refresh pivot table

    Under PivotTable Options, Layout & Format tab, uncheck Autofit column widths on update

  3. #3
    Registered User
    Join Date
    07-01-2013
    Location
    los angeles
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: how to stop Expand Entire Field when Refresh pivot table

    Quote Originally Posted by JieJenn View Post
    Under PivotTable Options, Layout & Format tab, uncheck Autofit column widths on update
    Thanks for the suggestion.
    I can't get the problem to reproduce now (it doesn't always happen).
    So I don't know if it works for me yet.

+ 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