I have a workbook with multiple Power Queries, some of which directly feed into Pivot Tables. When entering new data and clicking the Refresh All button under the Data tab, all of the corresponding queries (queries that pull in the new data from whichever query table is updated) are updated, but none of the Pivot Tables that reference data from the Power Query tables are updated. The only way I have found to refresh the Pivot Table is to click on the Pivot Table and click on the Refresh button under the PivotTable Tools Analyze tab.

I know that the Refresh All button under the Data tab is supposed to refresh everything, including Pivot Tables, so why is it not working for me?