Auto update slicer

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.

Thank you!

By: Katie

397 thoughts on “Auto update slicer

  1. Baixar Aplicativo Iptv

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. App Iptv Smarters Pro

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  3. Aparelho Iptv Via Internet

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  4. Huruf Timbul

    I simply needed to thank you thus much again. I feel not sure the items that I would include gone through without typically the form of hints revealed simply by you regarding that circumstance.

  5. tempat rekreasi depok

    It’s a shame an individual don’t have a give money button! I’d certainly give to the brilliant blog! My partner and i suppose at the moment I’ll resolve for book-marking and including your RSS feed in order to a Google account. I actually anticipate fresh updates in addition to will speak about this blog site with my Facebook party. Chat soon!

  6. produksicetak.com

    My lover and I stumbled more than here different website in addition to thought I might mainly because well check things out and about. I like the issues i see so nowadays I’m following you. Appear forward to checking out and about your on line site repeatedly.

  7. UFA124

    I was examining some of your articles on this internet site and I believe this internet site is rattling instructive! Keep putting up.

  8. Burbank realtor

    You could definitely see your skills within the paintings you write. The sector hopes for more passionate writers like you who are not afraid to say how they believe. All the time go after your heart.

Comments are closed.