View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Does anyone know.....

Hi Aly

If your model is anywhere approaching 65536 rows, then before starting I
would think very hard about the design and whether you need to have such
a large table.
If you do, then you would be much better off using something like Access
to handle this volume of records.

--
Regards

Roger Govier


"aly" wrote in message
...

Thanks! i checked and mine had 65536 rows too...i wanted to know
because
i am making a big spreadsheet and was wondering if it would all fit
in.
Many thank! Aly :D






Roger Govier Wrote:
Quite right Sandy.
My memory is not as good as it used to be!!!
and I was too darned lazy to fire up my copy of XL97 to check.

--
Regards

Roger Govier


"Sandy Mann" wrote in message
...--
XL97 16384-

I think that you mean XL95 had 16384, my XL97 has 65536 rows

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Roger Govier" wrote in message
...-
Hi Aly

It depends on the version
XL97 16384
XL 2000, XL2002 and XL2003 65536
XL2007 1 million

--
Regards

Roger Govier


"aly" wrote in message
...-

how many rows does excel have? please let me no if u no...thx a
bunch!x
x x




--
aly-

-

-





--
aly