Hi,

I have a inventory dashboard outlining price changes for approx 900 items presented with pivots, pivot charts, and using slicers. The user will select and view about 10 items at the the same time using the slicers. However every time I click the remove filter button in the slicer I get "The maximum number of data series per chart is 255" - which is understandable but annoying. So I tried suppressing that message using a macro I assigened to a separate button in the Excel sheet but it won't work.

The macro looks like this:

Application.DisplayAlerts = False
ActiveWorkbook.SlicerCaches("Slicer_Itemnumber").ClearManualFilter
Application.DisplayAlerts = True

But the message keeps appearing - does anyone know why and how I can suppress the message?

Thanks!