If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table - fix column size
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 |
#2
|
|||
|
|||
Pivot Table - fix column size
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. -----Original Message----- 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 . |
#3
|
|||
|
|||
Pivot Table - fix column size
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? -----Original Message----- 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. -----Original Message----- 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 . . |
#4
|
|||
|
|||
Pivot Table - fix column size
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? -----Original Message----- 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. -----Original Message----- 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 . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Month Data in a Pivot Table? | Kent | General Discussion | 3 | July 14th, 2004 01:32 AM |
Pivot Table column to column measurement | Mel | Worksheet Functions | 0 | April 12th, 2004 10:13 AM |
Change Order of Values in a Pivot Table Column Field | JulieD | Worksheet Functions | 1 | March 17th, 2004 04:24 AM |
Pivot Table with Duplicate Field Names | Michael Bayuk | Worksheet Functions | 5 | March 15th, 2004 07:32 AM |