Row Limit

[SgtPepps]

Does anyone know If you can up the amount of rows in an Excel Spreadsheet? Currently its about 65000 but i need over 100,000, can this be done?

Regards

Mike

 

[Zathras]

Nope. 65,536 is all she wrote.
Time to re-think the design of your application.
Or use Access.

 

[carrr]

You can "double up" rows, stretching out Excel's limits (i.e. two rows on each row columns A-E are one set, F-J are another, etc.) -- remembering that you've got 256 columns to use-, or, you could use Access.

 

[SgtPepps]

A rethink is in order, its not a big problem, thanks anyway

 

[SkipVought]

Hey sarg,

The answer is yes and no. No - a sheet in Excel has a maximum of 2^16 = 65536 rows.

But don't let that stop you -- well it just might slow you down to a crawl. Depends what you need to do with the data on the sheet(s). So...

what are you gonna do with your 100,000+ rows of data in Excel? Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SgtPepps]

I just wanted to be able to open a .dbf with over 90,000 records so I could easily manipulate it. I'm not a hot shot with FoxPro so Excel seemed like the logical solution. I've just filtered out the 7000 records I need using FoxPro so I’ll be able to open it now. I'm still interested in what you were going to suggest though.

Thanks

Sgt

 

[combo]

The spreadsheed in Office Web Components has 256K of rows, you can embed it in office application, but I know nothing about its functionality.

combo