VBA Refresh all does not refresh pivot tables

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

Sub Fiscal_Year_14()
Application.Worksheets("Menu").Range("H22") = "2014"
End Sub

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...

ActiveWorkbook.RefreshAll

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.