Reset filter code only works on my machine

[uson]

Hi all,

We have a group workbook used by multiple people (some 2003, some 2007) - most columns have filters. I have some code - below - that I got from this site (MrExcel has been so helpful!!) placed in ThisWorkbook to execute when it opens to reset the AutoFilters so the user opening the workbook will see all the rows of the spreadsheet. The workbook is saved as a XLSM file. The code worked fine when I tested it on my machine but does not reset the filters for other users (2003 and 2007). What am I missing?


Private Sub Workbook_Open()
Sheets("Portfolio").Select
On Error Resume Next
ActiveSheet.ShowAllData
Err.Clear
End Sub

Thanks.

 

[kpark91]

It is because your file is saved as "XLSM" file.
This type of file is only supported by XL2007 and above.

I suggest you re-save the file as "xls (98-2003) file" and see what happens.


If you are using a table functionality in excel2007, you will notice colors have disappeared in the excel2003.

Didi you create the filters with VBA or just manually?