• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 731
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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