I just want columns 2,4,6,7 to have the autofilter option. I know I can do 2-7 but I don't want column 5 to have this option and I can't use 'ALL'. Is there any option where I can just specify my column numbers? I tried autofilter='2,4,6,7' which didn't work.
Reviewed your code - I typically don't have multiple statements, such as your code shows with the ODS tagsets.excelxp (multiple) statements.
Suggest you start out by minimizing the tagset parameters, coding all on one ODS statement -- this helps narrow the scope of possible root problem causes. Then begin adding parameters and testing yourself.
If, after your own thorough testing the outcome is undesirable, suggest you contact SAS tech support and open a track, providing exact symptom. And you may want to work with the SASHELP.CLASS file first, if that data is suitable for some basic testing.