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?
jbcbussoftAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jbcbussoftAuthor Commented:
That does the trick. Thanks for your help. You get the gold star and my appreciation.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

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.