How do I increase file limitations to convert a file to Excel?
I am trying to convert a large data file from our route accounting software
to an Excel worksheet format. Everytime I try the data populates the worksheet through row 16385 and stops and the remaining data is lost. How can I increase the Excel file size to accomodate all my data? |
I used to experience the same problems importing AS/400
queries into Excel 97. When I upgraded to XL2002, I was able to import beyond 16K+ rows into 1 sheet. The Microsoft KB wasn't much help, but take a look anyway: http://support.microsoft.com/default.aspx?scid=296053 HTH Jason Atlanta, GA -----Original Message----- I am trying to convert a large data file from our route accounting software to an Excel worksheet format. Everytime I try the data populates the worksheet through row 16385 and stops and the remaining data is lost. How can I increase the Excel file size to accomodate all my data? . |
All times are GMT +1. The time now is 12:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com