I have a table from an external data source, and some calculations in it, from this table I created pivot tables.
When I press "refresh all" it only updates the table and not the pivot tables. When I press it another time it the pivot tables are refreshed.
Is there a way to make sure it's done by pressing the refresh all only once, maybe by changing the order in which excel refreshes the tables?