Remove filter (to show all) in Pivot Table via Macro

[mick0005]

Good evening.

• I have a pivot table with roughly 9 columns/fields which can be filtered upon.
• I find that people filter on a field and then save the workbook, leaving it filtered for the next person and they think data is missing
• I'd like to be able to write a macro and assign it to a button so that it unfilters (ticks SHOW ALL) for each of the fields in the pivot table.

Can anyone help with this? I have provided an image of the table. The pivot table is on sheet, "Report"

 

[mick0005]

Hoping I haven't received responses because I posted this late at night and not because it can't be done

Please help

 

[mick0005]

Still at work going on 15 hours BUMP! Someone please help with this?