Query Refresh

M

Mark Bridger

In the "Query Refresh" pop up dialogue. I accidently
clicked on "enable automatic query refresh for all
workbooks and do not show this warning again."

I need to diasable automatic refresh. Once I open my
clients excell sheet everything in excell just hangs up
and goes white. I can't access any toolbars.
 
G

Guest

I tried microsoft support and they couldn't figure it
out. So I fixed it. It's a sad day when a graphic
designer knows more about windows software than a
microsoft support representative.

This is how I fixed it.

under the start menu go to run
Type regedit

go to HKEY_CURRENT_USER
Software
Microsoft
Office
10.0
Excel
Options
and then delete the value named "QuerySecurity"

and presto. You can get the pop up again.
 

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

Parametrized value does not always refresh query 1
Query Refresh 1
Automatic Query Refresh, Changing Parameter 3
MS Excel Error: Too many client tasks 1
automatic query refresh 1
excel external data range "failed to refresh" 0
Workbook Open bypasses Query Refresh 3
excel external data range failed to refresh - second try 1

Top