Maybe you could have a little macro run each time the worksheet calculates:

Right click on the tab that contains the pivottable.
Select View code
paste this into the code window:

Option Explicit
Private Sub Worksheet_Calculate()
Me.UsedRange.Columns.AutoFit
End Sub


Back to excel and test it out.

Lyman Adrian wrote:

Dave,

I created a pivot table. The only problem is that the cell widths keep
changing to very wide every time I move different data into the data field.
I "autofit" the columns and they get narrow again, but as soon as I change
something in the data field area again, they revert back to very wide. I
want to keep them narrow so I can see them on one screen, not scroll over and
over.

Any ideas how to lock cell widths? Or have autofit automatically adjust
cell widths?

Thanks,

Lyman Adrian
--
Lyman Adrian
USAF (ret)

"Dave Peterson" wrote:

I'd check to see if there's a textbridge addin being loaded when excel starts.

(I don't use the Textbridge software with my scanner.)

Tools|Addins
(If you find it here, uncheck it)

Or maybe in your XLStart folder.
(if you find it here, move it somewhere nice and safe--just in case you ever
want to use it later.)

If the toolbar is still there after you've turned off/moved the file, then
tools|customize|tooblars tab|uncheck the Textbridge toolbar.
(Or select it and delete it????)

Maybe the combination of turning everything off and removing it would keep it
turned off.

===
Textbridge does have different problem (not that you described). One of the
solutions for that is to move TBRun##.xls (or remove it). (TBRun97.xls comes up
often with this problem.)

You could use windows start button|search and look for:
tbrun*.xls

if you have trouble finding it.

Ann Shaw wrote:

Dave - You're wonderful. Never knew you could do all of that. I copies my
icon from Word and pasted it into Excel (the default icon in Excel was blank).

Now my only toolbar problem is one that was left over when I uninstalled a
program called TextBridge. I've got it in both Word & Excel. Have tried to
delete, but it's back everything I restart either program. Guess it's in the
registry of somewhere else I don't know where to look.

You have a great weekend and, again, thanks for all of your help.

Ann

"Dave Peterson" wrote:

I didn't look at the picture, but you can do this:

Tools|customize (again, just so that dialog is visible)
rightclick on the "autofit selection"
You can change the the icon there
You can change it to the default style

There's a few options you may want to play with.


--

Dave Peterson


--

Dave Peterson