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

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.

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.

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.