I have a spreadsheet at work which downloads financial data for 20+ companies into one workbook. I've recorded a very simple macro to update the data which just runs the Refresh All command on the External Data toolbar.

However, I've found that from time to time individual download sheets become "dead" i.e. the Refresh Data command on the External Data toolbar becomes inactive for that particular sheet. Does anyone know why this might be happening?

Thanks

NeilF