How many entries can Excel handle!?
 

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be
when entries get tossed out?

How many entries can Excel handle!?
 

You are no where near the limit. Check out the help file article "Excel
limits and specifications". There must be something else going on.

--
Best Regards,

Luke M
"Rebecca Sage" wrote in message
...
I have close to 1000 entries in my Excel spreadsheet, and am trying to
figure
out why entries are coming up missing. I often do custom sorts. This may
be
when entries get tossed out?

How many entries can Excel handle!?
 

EXCEL 2007 can handle:-

1,048,576 rows by 16,384 columns

Please hit Yes if my comments have helped.

Thanks.



"Rebecca Sage" wrote:

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be
when entries get tossed out?

How many entries can Excel handle!?
 

And Excel 2003 has a limit of 65535 rows and 256 columns.

Your 1000 entries really should not be a problem. Have you checked to see
if perhaps your special sorting has placed some entries in places on the
sheet where you may not be looking?

A quick way to find out how far down and over on a sheet your data extends
is to click in a cell on a sheet and then press [Ctrl]+[End]. This will take
you to the lower right corner of the used range on a sheet. You can then
start looking to the left and up the sheet for your data.

"Rebecca Sage" wrote:

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be
when entries get tossed out?

How many entries can Excel handle!?
 

1000? that is a filter limit for unique items.

Rebecca Sage wrote:

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be
when entries get tossed out?

How many entries can Excel handle!?
 

xl2003 and below will only show 1000 unique entries in the autofilter dropdown.

But you can use a custom filter and type in what you're looking for (use
contains???).

Rebecca Sage wrote:

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be
when entries get tossed out?

--

Dave Peterson

How many entries can Excel handle!?
 

You may have hit on it - perhaps she meant custom filtering rather than
custom sorting.

"Bob I" wrote:

1000? that is a filter limit for unique items.

Rebecca Sage wrote:

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be
when entries get tossed out?

.

How many entries can Excel handle!?
 

If that's the problem, try the advice at
http://www.contextures.com/xlautofilter02.html#Limits
--
David Biddulph


"Dave Peterson" wrote in message
...
xl2003 and below will only show 1000 unique entries in the autofilter
dropdown.

But you can use a custom filter and type in what you're looking for (use
contains???).

Rebecca Sage wrote:

I have close to 1000 entries in my Excel spreadsheet, and am trying to
figure
out why entries are coming up missing. I often do custom sorts. This may
be
when entries get tossed out?

--

Dave Peterson