View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
shah shailesh shah shailesh is offline
external usenet poster
 
Posts: 78
Default Excel2007 - More columns when importing ascii file?

You have to change the settings as under.

Click on Office ButtonExcel OptionsSaveSelect 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.


"MG" wrote in message
...
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?