Auto-refresh external data in Excel 2010

I have about 15 sheets that I update everyday.

At first i was using the "Refresh All" command (Under 'Data' tab), but it always crashed on me.
It seemed to update a few of the sheets, but it would never do all of them.. I always got some sort of error or it froze.

So, I have to do it manually.. Fortunately I found the keyboard shortcuts, and updating the 15 sheets now only takes me about 30-40 seconds in total.

But does anyone else have this problem with the "Refresh All" feature? Is this just a problem with Excel 2010?

It's only 30 seconds of my day, but it would still be nice to be able to do all 15 sheets with one click of a button.

Thanks,

Hi Globulous,

You can use the below line of vba code

Please Login or Register  to view this content.

Regards,
AM