Excel2007 - More columns when importing ascii file?

M

MG

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.
 
M

MG

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

Mail Merge Directory Conditional Page Break 0
xml import....Size limit?? Can the XML file be split?? 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
xml import problem 0
Excel to ASCII Fixed Format 2
Convert Excel file ti ASCII format to allow a SIFT transfer 1
Save Excel to ASCII format 2
Importing Ascii file to Excell won't include Null Characters 0

Top