Row limit in Excel

[Jon Chase]

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 ?

[Harald Staff]

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" <JonChase@discussions.microsoft.com> skrev i melding
news:C8E859BE-435E-4733-AD18-64D3837C9C58@microsoft.com...
> 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 ?

[Jon Chase]

Does anyone know where and how I can find out what is the root of this cause
? I have the error signature:

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" <JonChase@discussions.microsoft.com> skrev i melding
> news:C8E859BE-435E-4733-AD18-64D3837C9C58@microsoft.com...
> > 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 ?
>
>
>

[Duke Carey]

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 signature:
>
> 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" <JonChase@discussions.microsoft.com> skrev i melding
> > news:C8E859BE-435E-4733-AD18-64D3837C9C58@microsoft.com...
> > > 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 ?
> >
> >
> >

[Jon Chase]

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 ?

[AlfD]

Hi!

I do not know what your problem is or its solution. I do, however, notice that your recording of dates is erratic ( 05 or 2005, for example). Could your difficulties lie in varying formats?

Alf