Data Limitations for Linked OLE Object?

[sub1700]

Hello all,

I have an OLE object on my form and it is linked to an Excel worksheet. I am encountering a problem where it will not display all rows of the worksheet. It stops at the same row every time no matter what worksheet file I use. Also, I have tried adding columns and it still stops at the same row, however it will display the new columns of data. I have tried all of the SizeMode properties as well as changing the OLE object height at runtime and design.

My only guess is that there is some sort of data size limitation. However, I am not sure since I am relatively new to VB and I would appreciate any feedback ideas you may have.

Thank you for your time,

PJ

 

[bjd4jc]

How many rows are you talking about?

 

[sub1700]

I have a three page worksheet and the OLE control cuts off two-thirds of the way into the first page after 40-45 rows of information.