AFAIK you must release and reset but a macro with a worksheet_change event
could trigger this for you so that it would happen automatically.

--
Don Guillett
SalesAid Software

"Phillips" wrote in message
news:g4eub.229720$Fm2.229809@attbi_s04...
Hey there!
I am using Excel 2002 and I have a speadsheet that has prices in it.

If I have the filter set to (the filter criteria is much more complex than
this though) prices for items that cost $5.00.

Of I change an item to 4.59, it should not be seen. How can I get it to
re-update the rows shown, with out releaseing the filter and resetting it?
Is there something like refresh.filter or anything like that?

Thanks
Phil