how to use clear filters in excel by applescript

Scripting Forums AppleScript | Mac OS X
#1

Hi All,

I wrote a applescript to use advance filter date in excel. It works well and I wanna clear all filters in workbook.

I found in open dictionary and we can use “clear all filters” command, but I tried many times and failed. Could anyone help on it?

tell application "Microsoft Excel"
	activate
        clear all filters pivot table


end tell
#2

Hi,

this should clear all filters in the active workbook:

tell application "Microsoft Excel"
	activate
	tell every sheet of active workbook to show all data
end tell

Thanks,
Nik