View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich[_27_] Rich[_27_] is offline
external usenet poster
 
Posts: 13
Default 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