Solved

Office 2000 - EXCEL Pivot Table Column Width

Posted on 2001-06-04
2
496 Views
Last Modified: 2008-01-09
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
Comment
Question by:arcook
2 Comments
 
LVL 7

Accepted Solution

by:
q2eddie earned 50 total points
ID: 6152726
Hi, arcook.

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

Bye. -e2
0
 

Expert Comment

by:costello
ID: 6414740
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question