| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Row limit in Excel
Is there a row limitation in Excel ? Reason why I ask, I have a control that
reads rows out of a Database. I have the option of creating this report by dates. With one date, it will yield 5965 rows and I can open up that report. Now with just the next day's date, it will yield 6060 rows and the Excel file will be created, but it encounters a Microsoft error. There is no difference in the data. I can in fact make the dates shift and include the date range that was failing but it wouldn't go to the current - i.e. 4/23/2004 to 3/29/05 will fail but 4/24/05 - 03/29/05 will work, and if I move the dates - 4/23/2004 to 3/28/05 will work - so it has nothing to deal with the data, but the amount of data and I have narrowed it down to row limitation. Does anyone know of a row limitation in Excel ? |
|
#2
|
|||
|
|||
|
Hi
Each Excel worksheet (of which a workbook/file may contain several) is limited to 2^16 rows * 2^8 columns. Ctrl End Downarrow -in sequence, not simoultaneosly- will take you there. 6060 rows is nothing, the error is elsewhere. HTH. Best wishes Harald "Jon Chase" skrev i melding ... Is there a row limitation in Excel ? Reason why I ask, I have a control that reads rows out of a Database. I have the option of creating this report by dates. With one date, it will yield 5965 rows and I can open up that report. Now with just the next day's date, it will yield 6060 rows and the Excel file will be created, but it encounters a Microsoft error. There is no difference in the data. I can in fact make the dates shift and include the date range that was failing but it wouldn't go to the current - i.e. 4/23/2004 to 3/29/05 will fail but 4/24/05 - 03/29/05 will work, and if I move the dates - 4/23/2004 to 3/28/05 will work - so it has nothing to deal with the data, but the amount of data and I have narrowed it down to row limitation. Does anyone know of a row limitation in Excel ? |
|
#3
|
|||
|
|||
|
Does anyone know where and how I can find out what is the root of this cause
? I have the error signatu AppName: excel.exe AppVer: 11.0.6355.0 AppStamp: 40aa979f ModName: excel.exe ModVer: 11.0.6355.0 ModStamp: 40aa979f FDebug: 0 Offset: 0002e494 "Harald Staff" wrote: Hi Each Excel worksheet (of which a workbook/file may contain several) is limited to 2^16 rows * 2^8 columns. Ctrl End Downarrow -in sequence, not simoultaneosly- will take you there. 6060 rows is nothing, the error is elsewhere. HTH. Best wishes Harald "Jon Chase" skrev i melding ... Is there a row limitation in Excel ? Reason why I ask, I have a control that reads rows out of a Database. I have the option of creating this report by dates. With one date, it will yield 5965 rows and I can open up that report. Now with just the next day's date, it will yield 6060 rows and the Excel file will be created, but it encounters a Microsoft error. There is no difference in the data. I can in fact make the dates shift and include the date range that was failing but it wouldn't go to the current - i.e. 4/23/2004 to 3/29/05 will fail but 4/24/05 - 03/29/05 will work, and if I move the dates - 4/23/2004 to 3/28/05 will work - so it has nothing to deal with the data, but the amount of data and I have narrowed it down to row limitation. Does anyone know of a row limitation in Excel ? |
|
#4
|
|||
|
|||
|
Do you have the option to export your report into some format *other* than
Excel, such as a plain text file? What is your source application, by the way? Duke "Jon Chase" wrote: Does anyone know where and how I can find out what is the root of this cause ? I have the error signatu AppName: excel.exe AppVer: 11.0.6355.0 AppStamp: 40aa979f ModName: excel.exe ModVer: 11.0.6355.0 ModStamp: 40aa979f FDebug: 0 Offset: 0002e494 "Harald Staff" wrote: Hi Each Excel worksheet (of which a workbook/file may contain several) is limited to 2^16 rows * 2^8 columns. Ctrl End Downarrow -in sequence, not simoultaneosly- will take you there. 6060 rows is nothing, the error is elsewhere. HTH. Best wishes Harald "Jon Chase" skrev i melding ... Is there a row limitation in Excel ? Reason why I ask, I have a control that reads rows out of a Database. I have the option of creating this report by dates. With one date, it will yield 5965 rows and I can open up that report. Now with just the next day's date, it will yield 6060 rows and the Excel file will be created, but it encounters a Microsoft error. There is no difference in the data. I can in fact make the dates shift and include the date range that was failing but it wouldn't go to the current - i.e. 4/23/2004 to 3/29/05 will fail but 4/24/05 - 03/29/05 will work, and if I move the dates - 4/23/2004 to 3/28/05 will work - so it has nothing to deal with the data, but the amount of data and I have narrowed it down to row limitation. Does anyone know of a row limitation in Excel ? |
|
#5
|
|||
|
|||
|
Yes, I can export out to a TEXT file and that works just fine. The source
application is Powerbuilder 8.0 "Jon Chase" wrote: Is there a row limitation in Excel ? Reason why I ask, I have a control that reads rows out of a Database. I have the option of creating this report by dates. With one date, it will yield 5965 rows and I can open up that report. Now with just the next day's date, it will yield 6060 rows and the Excel file will be created, but it encounters a Microsoft error. There is no difference in the data. I can in fact make the dates shift and include the date range that was failing but it wouldn't go to the current - i.e. 4/23/2004 to 3/29/05 will fail but 4/24/05 - 03/29/05 will work, and if I move the dates - 4/23/2004 to 3/28/05 will work - so it has nothing to deal with the data, but the amount of data and I have narrowed it down to row limitation. Does anyone know of a row limitation in Excel ? |
|
#6
|
|||
|
|||
|
Yes, I can export out to a TEXT file and that works just fine. The source
application is Powerbuilder 8.0 "Duke Carey" wrote: Do you have the option to export your report into some format *other* than Excel, such as a plain text file? What is your source application, by the way? Duke "Jon Chase" wrote: Does anyone know where and how I can find out what is the root of this cause ? I have the error signatu AppName: excel.exe AppVer: 11.0.6355.0 AppStamp: 40aa979f ModName: excel.exe ModVer: 11.0.6355.0 ModStamp: 40aa979f FDebug: 0 Offset: 0002e494 "Harald Staff" wrote: Hi Each Excel worksheet (of which a workbook/file may contain several) is limited to 2^16 rows * 2^8 columns. Ctrl End Downarrow -in sequence, not simoultaneosly- will take you there. 6060 rows is nothing, the error is elsewhere. HTH. Best wishes Harald "Jon Chase" skrev i melding ... Is there a row limitation in Excel ? Reason why I ask, I have a control that reads rows out of a Database. I have the option of creating this report by dates. With one date, it will yield 5965 rows and I can open up that report. Now with just the next day's date, it will yield 6060 rows and the Excel file will be created, but it encounters a Microsoft error. There is no difference in the data. I can in fact make the dates shift and include the date range that was failing but it wouldn't go to the current - i.e. 4/23/2004 to 3/29/05 will fail but 4/24/05 - 03/29/05 will work, and if I move the dates - 4/23/2004 to 3/28/05 will work - so it has nothing to deal with the data, but the amount of data and I have narrowed it down to row limitation. Does anyone know of a row limitation in Excel ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| Row Limit in Excel | Excel Discussion (Misc queries) | |||
| Can I change the 15-digit limit in Excel for numbers ? | Excel Worksheet Functions | |||
| How do I add more columns above the 256 limit in excel? | Excel Worksheet Functions | |||
Linear Mode
