Excel 2000 filter problems

[Steve Walford]

I have inherited a large excel file nearly 4000 rows long
The first column is a reference number and can be between 1 and 750
inclusive.

For information, the number repesents an electronic programable key
for use in a computerised fuel monitoring / issue system. The other
columns are used to record what vehicle is set up against each key,
other columns record similar data, ie. user departments, fuel type
etc.

If a fuel key is returned it can be reprogramed with different
references, the details of the original references are kept in the
spreadsheet.

Therefor if a filter is applied to the first column for say key number
5, all rows with the figure 5 in the first column should be displayed.

Unfortunately all rows are not shown, is there a limit to the number
of rows allowed in a spreadsheet. There does not appear to be any
blanks in the first column. If for instance I enter a unique figure in
the first column of the row following the last row this is picked up
when applying a filter

I know excel is not the best way of recording this data but as stated
I inherited the spreadsheet

Many Thanks

Steve

 

[Peo Sjoblom]

The dropdown will show up to 1000 items, for possible workarounds

http://www.contextures.com/xlautofilter02.html#Limits

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Steve Walford]

Thanks

Answered the question

Steve