Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 2003 row height format | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |