How do you avoid window that prompts to enable auto query refresh
 

How do you avoid window that prompts to enable the auto query refresh ? I
dont want users to see it.

How do you avoid window that prompts to enable auto query refresh
 

Try this:
Right-click in the data range
Uncheck: Refresh data on file open
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Peter_EZEM" wrote:

How do you avoid window that prompts to enable the auto query refresh ? I
dont want users to see it.

How do you avoid window that prompts to enable auto query refr
 

Ron,
Your solution avoids the window prompt but then I lose the automatic refresh
which is what I prefer. I dont want users to have to click on anything in
order for the chart to be refreshed automatically and displayed quickly.
Thanks for the suggestion though.

"Ron Coderre" wrote:

Try this:
Right-click in the data range
Uncheck: Refresh data on file open
Click the [OK] button

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Peter_EZEM" wrote:

How do you avoid window that prompts to enable the auto query refresh ? I
dont want users to see it.

How do you avoid window that prompts to enable auto query refresh
 

Thanks to KGOERZ for great tip regarding edit of registry for QuerySecurity
...works great. See KGOERZ recommended link...

http://support.microsoft.com/kb/248204

"Peter_EZEM" wrote:

How do you avoid window that prompts to enable the auto query refresh ? I
dont want users to see it.