Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is "fill handle". i don't see any fill handle in my excel | New Users to Excel | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Excel should handle more than 65,536 rows. | Excel Discussion (Misc queries) | |||
To many rows for EXCEL to handle | Excel Discussion (Misc queries) | |||
Am I trying to do something that Excel cannot handle? | Excel Discussion (Misc queries) |