Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 763
  • Last Modified:

How do you lock column width so imported csv file doesn't auto resize the columns

I have a spreadsheet that we import data into. The sheet is a template with a header row and some calculations. Every time we import, the column widths are changed. I have tried several suggestions found in various places but none of them seem to work. I need to be able to add data to the sheet. A protected sheet stops this. What do I need to do to keep my header row like it is and still be able to IMPORT data?
0
jbcbussoft
Asked:
jbcbussoft
  • 3
  • 3
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
If you are doing the import now with VBA then what I suggest is importing into a new worksheet and copying the data from that worksheet to your main worksheet. This way you can maintain control over what is changed in your main worksheet.

Kevin
0
 
jbcbussoftAuthor Commented:
I'm importing a csv file. As far as I know I  am not using Visual Basic.
0
 
zorvek (Kevin Jones)ConsultantCommented:
If you don't know if you are using VBA then you probably are not.

Would a VBA solution be acceptable?

How are you importing the data now?

Kevin
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jbcbussoftAuthor Commented:
We are using "Get External Data  From Text"
0
 
zorvek (Kevin Jones)ConsultantCommented:
When on the last panel of the import wizard click the "Properties" button and then uncheck "Adjust column width".

Kevin
0
 
jbcbussoftAuthor Commented:
That does the trick. Thanks for your help. You get the gold star and my appreciation.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now