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