Excel2007 - More columns when importing ascii file?

G

Guest

When importing an ascii (.txt) file in Excel 2007 I am still limited to the
256 column limit that of Excel 2003.
How can I import my full data set?
 
S

shah shailesh

You have to change the settings as under.

Click on Office Button>Excel Options>Save>Select Excel Workbooks(*.xlsx)
(from the first dropdown box)

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Excel Menu-2003 for Excel-2007)
If You Can't Excel with Talent, Triumph with Effort.
 
G

Guest

Thank you for the response, However after changing the settings as indicated
below, when importing the data, I am still limited to 256 columns??
Any other ideas?
 

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

xml import....Size limit?? Can the XML file be split?? 0
Drag text file to Excel -- stopped working 5
Ascii Page Break 2
Entering ASCII codes with Excel 2003 2
weird characters are displayed 1
Save Excel to ASCII format 2
Convert Excel file ti ASCII format to allow a SIFT transfer 1
Access Subscript out of range when importing into access 2010 from excel 0

Top