Refresh each excel sheet 1-by-1 using Macro/VBA

Hello All,

I have 100 sheets in my excel, and I can't run Refresh All, as it gives me error "[Microsoft] [ODBC Excel Driver] Too many client tasks."
So currently I have to go to each sheet and click "Refresh" button manually after 5-10 seconds delay.
How can I automate "Refresh" on all sheets by clicking one button with 5-10 seconds delay between each refresh?

Thanks in advance.

Hi,

Are those pivot tables you are trying to refresh?

If yes, you will need something like this

Please Login or Register  to view this content.