| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel2007 - More columns when importing ascii file?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel2007 - More columns when importing ascii file?
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? "shah shailesh" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert an Excel file to an ASCII file? | Excel Discussion (Misc queries) | |||
| Importing Ascii file to Excell won't include Null Characters | Excel Discussion (Misc queries) | |||
| importing ASCII | Excel Discussion (Misc queries) | |||
| Importing to Excel from ASCII | Excel Discussion (Misc queries) | |||
| How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
Hybrid Mode
