Data - Get External Data - New Database Query
Posted by SJC on March 20, 2001 3:23 PM
I accidentally selected the option to suppress the Query Refresh dialog box in the future. How can I undo this?
Posted by Mark W. on March 20, 2001 3:25 PM
Did it take you to Microsoft Query?
Posted by SJC on March 20, 2001 3:29 PM
No. When I first created the external link, I did it with Access.
Posted by Mark W. on March 20, 2001 3:42 PM
I use Oracle, but let me ask is there a Defined
Name to your External Data? If so, you should
be able to modify your properties using the
Data Get External Data Data Range Properties
menu command.
Posted by SJC on March 20, 2001 4:21 PM
I went there (Data Range Properties) and tried selecting the options in the Refresh Control section. Didn't work. I tried de-selecting them too but didn't see the dialog return.
Posted by Mark W. on March 20, 2001 4:29 PM
Wait a minute!
By chance are you referring to the External Data
toolbar? If so, you can restore it by choosing
the View Toolbar External Data menu command.
Posted by SJC on March 20, 2001 4:37 PM
Re: Wait a minute!
No. I know I can get to the External Data toolbar by choosing Data then Get External Data then Data Range Properties.
My original question has to do with security. If the external database to which my data range is referring becomes corrupted or infected and I know about it, I want to be able to tell Excel not to refresh the data. This is similar to choosing the Medium option in the Tools Macro Security command.
Posted by Mark W. on March 20, 2001 4:47 PM
Re: Wait a minute!
Hmmm, this must be an Access specific feature. I
never seen anything like it. Maybe, you ought to
re-post to get another "fish" on the line.
Posted by SJC on March 20, 2001 6:29 PM
Eureka!
I was able to reset the option. Below is the link to the article for how to do it. Microsoft has this warning: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.
http://support.microsoft.com/support/kb/articles/Q248/2/04.ASP?LN=EN-US&SD=gn&FR=0&qry=refresh%20external%20data&rnk=155&src=DHCS_MSPSS_gn_SRCH&SPR=XLW2K
Posted by Mark W. on March 21, 2001 7:21 AM
Re: Eureka!
Good stuff! Evidently this only applies to
Excel 2000.
