If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

"The Slicer Cache already exists" error macros

Thread starter dshafique
Start date May 14, 2018
Tags

kpi run time error slicer cache slicers vba

dshafique

Board Regular

May 14, 2018

hi all, Im working on a macros involving different pivot tables and slicers. When I run the following:

Code:

 ActiveWorkbook.SlicerCaches.Add(ActiveSheet.PivotTables("sAPivot"), _        "KPI 1 Percentage").Slicers.Add ActiveSheet, , "KPI 1 Percentage", _
        "KPI 1 Percentage", 155, 490, 145, 200

i get a run time error which tells me "the slicer cache already exists" i even changed the name from KPI 1 to sKPA and still no dice.

any reason why I would be receiving this error?

thanks!