External data range
 

Hi
I have a workbook with an external data range. It
refreshes correctly from the data source, however when I
hide the workbook (using Windows|Hide) it stops
refreshing. Is there a way to hide a workbook and still
refresh it?

The only solution I have (as of yet untested) is to create
a macro that will unhide the workbook long enough for the
refresh to occur and then hide it again.