Enable automatic query refresh for all workbooks?

[Guest]

I know there's a way (according to a KB article on Office 2000 SR1), and in
Office XP I must have turned this off somehow, since my workbook didn't ask
me everytime if it should refresh or not, but I can't seem to find where
this checkbox is in Office 2003!

 

[Immanuel]

This checkbox has been removed in XL2003 for security reasons. You cannot
off the prompt using the XL interface. Modifying the following registry key
will give you the same effect:

Path: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

Key: QuerySecurity

Values:

0 = Prompt on all workbooks

1 = Do Not Prompt on any workbooks, and do NOT allow automatic query refresh
for any workbooks

2 = Do Not Prompt on any workbooks and ALLOW automatic query refresh on all
workbooks (this, of course, is NOT recommended)



/i.

 

[Guest]

Thanks for the tip.

This checkbox has been removed in XL2003 for security reasons. You cannot
off the prompt using the XL interface. Modifying the following registry key
will give you the same effect:

Path: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

Key: QuerySecurity

Values:

0 = Prompt on all workbooks

1 = Do Not Prompt on any workbooks, and do NOT allow automatic query refresh
for any workbooks

2 = Do Not Prompt on any workbooks and ALLOW automatic query refresh on all
workbooks (this, of course, is NOT recommended)



/i.