I have a column of data organized by month. On a separate sheet, I have a pivot table and a slicer connected to this data. When I enter new data, I want the slicer to update itself rather than having to click May, June, etc. My file is .xlsm and the sheets are protected so no one can change the formulas. So the macro or formula would have to work around or within protection.
I already have a macro set up to update the table since it wont do it on it’s own becuase the sheet is protected. Now I just need the slicer.