I am preparing an important document and I need to be able to "freeze the
column width in a pivot table, so that when I enter more information the
column won't change and show: ####### instead of an amount.
thank you
I am preparing an important document and I need to be able to "freeze the
column width in a pivot table, so that when I enter more information the
column won't change and show: ####### instead of an amount.
thank you
All you need to do is select the pivot table column (hover over the field name until the black arrow shows up) and then left click to select the entire column of data. Once this is done you can set your column width for that column and when you refresh your data the column width won't change.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off.
Click OK
Martha Navarro wrote:
> I am preparing an important document and I need to be able to "freeze the
> column width in a pivot table, so that when I enter more information the
> column won't change and show: ####### instead of an amount.
>
> thank you
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks