column width pivot table

  1. DPChristman

    Pivot Tables and Shared Files

    I have a spreadsheet that is currently shared by about a dozen people/ I have two quick questions: I am often finding a temp version of the file (beginning with ~$) created in the directory, and it stays there well after the users are out of the file. This isn't s problem for me, because I...
  2. L

    VBA Macro set column width in a Pivot Table on creation

    For the life of me I can't find where I can set the Pivot Table's column size for just xlColumnField and I've spent far too much time on this simple little thing. grrrr I have several macros that auto generate pivot tables based upon criteria. I want the Autofit columns to be turned off after...
  3. T

    lock column widths in pivot tables

    this is frustrating...every I make a selection in one of the Page Fields the column widths change and the pivot table is not viewable on a single page. I have tried checking the box next to 'Preserve Formatting' in the Table Options view, but that does not work. suggestions appreciated...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top