Filter clearing in Excel when do "Save As"

[bdbBear]

I have a Excel file (2003) that has some filters on it.

When I do "Save As" the filters get cleared.

I added breakpoints to the various event-triggered sub-rountines on the ThisWorkbook object and the sheet object to see what is being triggered. However, none of those procedures were.

Does anyone know if filters are automatically cleared when the file is saved. And if yes, is there a way to prevent that from happening?

Thanks.

- Bruce

 

[Gavona]

Filters don't usually get cleared - at least not in Excel 2000. You probably have some code in there somewhere. Try opening without running the code - hold down SHIFT whilst opening the file - this stops any code from running

Are these advanced Filter, Autofilter or what?

Thanks,

Gavin

 

[bdbBear]

Hi Gavin,

It's an advanced filter set up using vba.

I'll try doing it holding down Shift.

Thanks.

- Bruce