I have this code to refresh a pivot table:

Hoja3.PivotTables("Tabla dinámica2").PivotCache.Refresh
Hoja7.PivotTables("Tabla dinámica4").PivotCache.Refresh
Hoja6.PivotTables("Tabla dinámica4").PivotCache.Refresh


The code works, but when I have 50 pivot tables, and I want to refresh all of them in the same time, th pc is blocked and I must to close the excel application. What can I do?