Default settings when opening a text file with Excel

  • Thread starter Thread starter David Fitzwater
  • Start date Start date
D

David Fitzwater

I need to know how to change a default setting. When I open a text file
(comma seperated) on my computer, I right click on it then choose "open with
Excel." The result is a fixed width, one column data block. When I try this
method on other machines, I get a poorly parsed mess because the default is
set differently. I have a collection of macros that I want to share with
other users in my office, but they can't use the macros because their data
does not have the same format. Since everyone is using the same software, it
seems that the default can be changed, but I can't find the setting and I
can't find any reference to it in the online help.
 
If you open Excel first then the *.txt file from within Excel you will get
the Text Import Wizard pop-up where you can parse the text as you wish.

Opening from "Open With" will not give you the Text Wizard


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change Default Settings for Data Import 1
csv files 1
importing text file to excel 1
Import of Text Delimited file into excell 1
How to change default date formula on Excel worksheet 2
set excel 2003 as default excel application 2
Workbook does not open by default in Excel 2007 2
open text file with excel 3

Back
Top