Feb 20 2018
03:44 PM
- last edited on
Feb 06 2023
03:03 AM
by
TechCommunityAP
Feb 20 2018
03:44 PM
- last edited on
Feb 06 2023
03:03 AM
by
TechCommunityAP
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 warning you get stating "Native Database Query"? I have about 25 Postgresql queries on 25 different Excel tabs. EVERY SINGLE TIME I want to update my date parameter, it asks me 25 times if I am aware I am running a native database query.
Can someone please help me? There are no instructions anywhere on how to do this in Excel 365...only how to do it in EVERY OTHER VERSION of Excel that has ever existed.
Thanks,
Joel
Aug 23 2018 01:31 PM - edited Aug 23 2018 01:34 PM
Same here. I added a few parameters tied to Excel cell values, and it asks me this every time. My Excel document was designed for some database-read-only people. It's lame that they have to freak out every time they see a bunch of SQL code and a warning whenever they change a parameter. I wish some simplified solution would be created by MS for using cell-originating query parameters.
Aug 23 2018 03:18 PM
Hi Joel
Kindly follow the steps given below to suppress the warning that you are getting "Native Database Query".
Open Excel - Click on Data - Get Data - Query Options. Once you click Query Options you will get another Pop up Window - Select Security - You will get Native Database Queries - uncheck "Require user approval for new database queries" & click on Ok.
You may refer to the screen shots below -
Thanks
Robin Nishad
Technical Consultant
Jan 22 2020 11:53 AM
@Robin Nishad : 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!
Apr 27 2020 11:23 PM
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.
Nov 26 2020 06:22 AM