more than 65,500 rows

N

Nick Hodge

Not got huge functionality but if you save a blank workbook as a webpage
with interactivity you will get an OWC spreadsheet (Office Web Component).
This has 262144 x ZZZ (Whatever that is!)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
F

frankp23

Thanks for all feedback and fun-
I need from 70-110 rows and then ability of prgram to weedout duplicates
which are typically 30% and then a bunch of other analysis.

When I try to filter on unique records I keep getting an eror meddage from
Excell saying data is too complicated when I have toremove duplicates from
50K records.
Even when I have each reord in increasing numerical order- but since it is
alpha numeric in text I think Excell drops the ball.

I bought macro systems Duplicate finder add in to see if it might do the jop
but don't know yet
 
H

Harlan Grove

Andy Wiggins wrote...
Quattro Pro can handle up to one million rows and one million columns.
....

Really?! I have QP10 (WPO 2002), and it only goes out to column ZZZ,
which is column number 18,278. FWLIW, WingZ provided > 30K rows by >
30K columns back in the early 1990s, and most Unix-originated
spreadsheets span at least 512 columns.
 
L

leaftye - ExcelForums.com

Nick Hodgewrote:
Not got huge functionality but if you save a blank workbook as a
webpage
with interactivity you will get an OWC spreadsheet (Office Web Component).
This has 262144 x ZZZ (Whatever that is!)

Or make a form and drop that OWC (MS Office Spreadsheet 11.0) control
on it. AFAIK, it retains much, if not all, of the normal spreadsheet
functionality. BTW, it's 18,278 columns.

Eugene
 
Top