Solved

Column Width keeps changing

Posted on 2001-06-19
4
185 Views
Last Modified: 2008-03-06
I have excel files that keeps changing the column width.  When I make the change (open the columns) and then save the file, I reopen the file and it still show the column width too small.

Do anybody know why this is happening?
0
Comment
Question by:vhooper780
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 22

Accepted Solution

by:
Dreamboat earned 50 total points
ID: 6208830
On what type of field?

If the date fields are formatted as 00/00/00, and your PC (regional settings) is set to show 00/00/0000, this could cause this problem, I think.

Look in the folder on your PC called XLSTART. Is there anything in there? Close Excel, remove any files from XLSTART and launch Excel again, open the file. Same problem?

Tools-Options-General tab contains an alternate startup directory. If there's anything in there, remove it for now. Close and reopen Excel and then the file. Does that help?
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6208833
Oops. If it's a date field problem that is happening, select the column, hit Format-Cells and set the date format to 00/00/0000 IN THE EXCEL FILE TOO.
0
 

Author Comment

by:vhooper780
ID: 6212042
Thanks, it worked.
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6212434
Terrific!
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

734 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