> My worksheet includes an external query set to run when the file is opened.
>
> Whenever the file is opened, the user gets prompted to enable automatic
> refresh.
>
> Is this possible to automatically bypass? I'd like the query update to
> happen seamlessly without any prompting.
>
>
>
>
>
> > My worksheet includes an external query set to run when the file is
opened.
> >
> > Whenever the file is opened, the user gets prompted to enable automatic
> > refresh.
> >
> > Is this possible to automatically bypass? I'd like the query update to
> > happen seamlessly without any prompting.
> >
> >
> >
> >
Excel Programming >> Disable prompt for external query
Hall,
These are office policies, and control how every user sees and uses the
office suite.
The section you need is further down under 'Policies in the Excel policy
template'. If you talk to your system administrator about this, then they
should be able to configure the system to automatically update the query when
you open it.
I hope you can work it out!
Richard
> Richard
>
> I have no idea what this means. I'm not sure if you sent me to the wrong
> page or to a specific piece and context or explanation is provided
> elsewhere.
>
> Please give me a bit more guidance on this...
>
> Thx!
>
> >
> > > My worksheet includes an external query set to run when the file is
> opened.
> > >
> > > Whenever the file is opened, the user gets prompted to enable automatic
> > > refresh.
> > >
> > > Is this possible to automatically bypass? I'd like the query update to
> > > happen seamlessly without any prompting.
> > >
> > >
> > >
> > >
>
>
>
