Automatic Refresh in Addin
 

Hi,

I have a spreadsheet using a web query for external data. Works fine.

However when I try and save as an addin, the auto refresh does not work...

Is there any way to turn this on for add-in?
Is this behaviour by design?
Any better workarounds than ThisWorkbook.RefreshAll on a timer?

Thanks
Rich