more than 65,500 rows

  • Thread starter Thread starter Guest
  • Start date Start date
I doubt the OP just wants to squeeze less than 36 in there...

Mangesh
 
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
(e-mail address removed)
 
Quattro Pro can handle up to one million rows and one million columns.
 
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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top