Excel 2003 Limitations?
Is there a maximum file size for Excel 2003 and or other limitations on the
amount of rows / data that it can store? We have an application that is trying to automatically import roughly 132,000 records into an excel file and only 16+ thousand are shown. Any ideas? Thanks! |
Excel 2003 Limitations?
<only 16+ thousand are shown
Is a record a row? Excel has a limit of 65536 rows per worksheet. You can use more worksheets, but that generally doesn't make things easier. Check HelpSpecifications. -- Kind regards, Niek Otten "Transam388" wrote in message ... Is there a maximum file size for Excel 2003 and or other limitations on the amount of rows / data that it can store? We have an application that is trying to automatically import roughly 132,000 records into an excel file and only 16+ thousand are shown. Any ideas? Thanks! |
Excel 2003 Limitations?
"Transam388" wrote in message ... Is there a maximum file size for Excel 2003 and or other limitations on the amount of rows / data that it can store? We have an application that is trying to automatically import roughly 132,000 records into an excel file and only 16+ thousand are shown. Any ideas? Thanks! Start learning to use Access instead of Excel. |
All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com