Stop column width from changing on pivot table....?

  • Thread starter Thread starter myk
  • Start date Start date
M

myk

Hello All,

I have a worksheet where I need a column to be 315 pixels wide all the
time. This column is part of a pivot table. Whenever I change the
page option though (via the pull-down list), the column that needs to
stay at 315 pixels shrinks back in size to something smaller. Any
ideas on how to get it to stay at 315 pixels wide?

TIA,

myk
 
Myk,

Just uncheck the Autoformat table option, in the Pivot Table Options Page
(Table Option in context menu)...

Best,

RGO
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ColumnWidths, Characters & Pixels 5
Resizing Pivot table column 2
Pivot tables and column widths 1
Pivot Table column widths 2
listbox - code to adjust column widths 4
Change Pivot Table Filter Based on Cell Value 0
Setting Pivottable RowField Width 2
Setting column width on different computers 4

Back
Top