View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick Douglas Nick  Douglas is offline
external usenet poster
 
Posts: 1
Default Automatic query data refresh with template-- system or file setting?

Hello,

I have a template that I am setting up to refresh automatically when it
opens. I am testing it for the first time and got a dialog box in which
I choose to enable or disable automatic refresh.

My question is, is this a file-specific setting, or
application-specific?

There are many users who will be using this spreadsheet and I don't
want them to encounter any kind of dialog box at all -- I'm hoping the
setting is file-specific and will be saved when I close and save the
template again.

Can anyone help?
Thanks!