Solved

Column Width keeps changing

Posted on 2001-06-19
4
187 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

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…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
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…
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 …

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