• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 516
  • Last Modified:

Office 2000 - EXCEL Pivot Table Column Width

What is the procedure to Lock the column width's in a pivot table.  Currently when the pivot table refresh's, the column width's change.
0
arcook
Asked:
arcook
1 Solution
 
q2eddieCommented:
Hi, arcook.

Right-Click on a cell inside the pivotTable.
Select the "Options" menu item.
Uncheck the "AutoFormat Table" checkbox.

Bye. -e2
0
 
costelloCommented:
If no objections are made in the next 5 days, I will force accept the contribution by q2eddie.

costello
Community Support Moderator @ Experts-Exchange

P.S. This post is made as part of the general effort to clean up this topic area, meaning, looping through all the open questions with no activity since 21 days.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now