Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    multiple pivot auto column width adjust (Excel 2003 / SP2)

    Can anyone explain how I can prevent all of my pivot tables from automatically adjusting the column width? i have multiple pivots on one sheet and each time I "refresh all," the data column with adjust the column width. I've already tried fixing the Table-Options for "preserve formatting" and "auto-format table," but neither one worked. I've attached a sample of how the pivots are laid out. I've pasted values so that it could fit within the size restriction.
    Attached Files Attached Files
    thanks
    christine

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multiple pivot auto column width adjust (Excel 2003 / SP2)

    If you CLEAR the check box "AutoFormat table" in the PivotTable Options dialog, Excel should leave column widths alone.
    Attached Images Attached Images
    • File Type: jpg x.jpg (47.1 KB, 0 views)

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: multiple pivot auto column width adjust (Excel 2003 / SP2)

    OH MY GOODNESS! Dummy alert! I KNEW that I had already cleared all of the "auto-format" fields. I KNEW I already checked that twice before I reached out to you. But of course...when I went back in to check the settings on all of my tables again, some gremlin got in there and changed it back to auto-format on me. When I changed it and ALL of the pivot tables were set to NOT auto-format, of course it did work perfectly. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    THANK YOU...YET AGAIN!
    thanks
    christine

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multiple pivot auto column width adjust (Excel 2003 / SP2)

    Things like that happen to me too! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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