Forum

Notifications
Clear all

Refresh time with many tables

2 Posts
1 Users
0 Reactions
151 Views
(@dillon240)
Posts: 3
Active Member
Topic starter
 

I have created a workbook with 17 tables on one sheet. I have written a macro to refresh all tables when I leave a certain sheet. The problem is excel takes 30-45 seconds to refresh. This is very annoying. Is there a way to speed it up? 

 
Posted : 28/06/2019 1:37 pm
(@dillon240)
Posts: 3
Active Member
Topic starter
 

Sorry. I should specify. There are 17 Pivot tables on one sheet and a total of 22 Pivot tables in the workbook. 

 
Posted : 28/06/2019 1:39 pm
Share: