Hi there,

Need assistance with this run time error:

'-2147417848 (800 10 108)':
Method 'Refresh' of object 'PivotCache' failed

Just by clicking on any of the slicers, this run time appears. Please need help to solve this.

The following line in highlighted in the debug:

Worksheets("Priority Areas").PivotTables("PivotTable5").PivotCache.Refr esh

File attached

Thanks in advance.

Regards,

Patrick

Attached Files

Excel file A.xlsm (47.9 KB, 9 views)