P
Peter_EZEM
How do you avoid window that prompts to enable the auto query refresh ? I
dont want users to see it.
dont want users to see it.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How do you avoid window that prompts to enable auto query refresh
R
Ron Coderre
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
Right-click in the data range
Uncheck: Refresh data on file open
Click the [OK] button
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
P
Peter_EZEM
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.
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 said: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 said:How do you avoid window that prompts to enable the auto query refresh ? I
dont want users to see it.
P
Peter_EZEM
Thanks to KGOERZ for great tip regarding edit of registry for QuerySecurity
...works great. See KGOERZ recommended link...
http://support.microsoft.com/kb/248204
...works great. See KGOERZ recommended link...
http://support.microsoft.com/kb/248204