Pivot Table - fix column size

  • Thread starter Thread starter Melanie H
  • Start date Start date
M

Melanie H

I can select a column and set the width after
using "enable selection", and the new width sticks as
long as I only refresh the pivot table with the refresh
button within the Pivot Table Toolbar.
However, most of our users use the "Refresh All" button
on the External Data Toolbar, because it refreshes ALL
pivot tables in the workbook. This is causing the column
width to revert to the previous width.
What can we do so that column width changes stick after
the "Refresh All" button is used?
Thanks, Melanie
 
I think Im using a different version of excel than you
because I see options like preserve formatting and
autoformat table. Unchecking autoformat and checking
preserve formatting works for me and maintains column
width for both refresh options.
I dont know if this helps you.
 
I am using Excel 2003.
I have tried what you suggested, my column still snaps to
be too narrow if I use "refresh all".
Thanks anyway; any other suggestions, anyone?
 
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

Pivot tables and column widths 1
Column width of Pivot Table data goes back to default when data refreshed 2
freeze width of a column used by pivot table 4
column width in autoformatted pivot table 5
Pivot Table refresh 3
Pivot table column widths 1
Pivot Tables 1
Refresh order when refreshing all in a workbook 1

Back
Top