VBA Refresh all does not refresh pivot tables

So I have a couple text boxes that I assigned a macro to...

Please Login or Register  to view this content.

Basically, I have a worksheet named data and that sheet has a table that is from a query in Access and this is where all my data comes from. The code above is one of four and what I am doing is creating a button for a user to click on that will allow them to select 2014-2017 so each button changes the data to a different year. I took that same code and added...

Please Login or Register  to view this content.

I have three different worksheets with pivot tables in them and when I run this it refreshes everything except those pivot tables. What am I missing?

I should also mention that in this particular workbook I have all tabs hidden so the only way to get to each worksheet is through a text box that is linked to each worksheet. Not sure if this has something to do with it.

I have had this issue. So I just started explicitly (and redundantly) refreshing EXPLICIT pivot tables. It isnt much more code and doesnt take much longer, but no drama once coded.