Excel2007 - More columns when importing ascii file?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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?
 
Back
Top