All column width changed after reopening a file

[Kok Fai Leong]

Wonder if anyone can advice me on how to stop this from happening. I've to
reset all my column width everytime I reopen my excel files. This is really
frustrating.

Thanks in advance.

 

[Geoff Lilley]

Try trashing the file com.microsoft.excel.plist, which can be found in:

your hard drive/users/your name/library/preferences/

If that doesn't work, try inserting this code in your Personal Macro
Workbook:

Private Sub Autpen()
Dim wb As Workbook
For Each wb In Workbooks
Selection.CurrentRegion.Select
Selection.Columns.AutoFit
Next
End Sub

Cheers,
Geoff Lilley
Microsoft Office Master Instructor (2000/XP)
Apple Certified HelpDesk Specialist (OS X 10.4)