I have now managed to recreate this error. It always seems to happen
when you save the file and then attempt to apply a custom filter before
making any other change to the spreadsheet. Various custom rules seem to
cause it (e.g. does not contain, contain, starts with, etc).

When you click OK, you get all of the correct data but the filter
drop-down boxes fail to expand, so you have to remove the filter and
re-apply it.

Any ideas?

Cheers

Gaz


--
gazbea
------------------------------------------------------------------------
gazbea's Profile: http://www.excelforum.com/member.php...o&userid=28644
View this thread: http://www.excelforum.com/showthread...hreadid=483086