Forum Discussion

Joel Harmon's avatar
Joel Harmon
Copper Contributor
Feb 20, 2018

Excel 365 Native Database Query Warnings

I have searched far and wide and there is currently no one on the entire Internet that has answered this question yet:   In Excel 365, how do I get to Options-->Security in order to suppress the ...
excel
PBellerose's avatar
PBellerose
Copper Contributor
Jan 22, 2020

Rnishat0786 : Since this is a Global setting, I'm guessing this only applies to local machine and it should be set on all machines that will open the workbook?

 

If so, anyone know what is the registry key and what it should look like?

 

Thanks!

HansWS's avatar
HansWS
Copper Contributor
Apr 27, 2020

PBellerose 

This page has an answer about RegKeys.

https://stackoverflow.com/questions/37186442/always-allow-native-db-queries

 

Thanks for this simple set of screen shots!  Spent an hour looking for this.