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

G

Guest

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

Guest

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
 
G

Guest

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 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.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stopping "Query Refresh" messages 2
Prompting to allow External Query Data Refresh 3
Query Refresh 1
query to external data 3
Refreshing a query 1
How do break the link from my excel workbook to a access database. 4
How to disable the pop up for enable auto update? 2
How to enable query refresh? 3

Top