Excel 365 Native Database Query Warnings

%3CLINGO-SUB%20id%3D%22lingo-sub-161962%22%20slang%3D%22en-US%22%3EExcel%20365%20Native%20Database%20Query%20Warnings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-161962%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20searched%20far%20and%20wide%20and%20there%20is%20currently%20no%20one%20on%20the%20entire%20Internet%20that%20has%20answered%20this%20question%20yet%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Excel%20365%2C%20how%20do%20I%20get%20to%20Options--%26gt%3BSecurity%20in%20order%20to%20suppress%20the%20warning%20you%20get%20stating%20%22Native%20Database%20Query%22%3F%26nbsp%3B%20I%20have%20about%2025%20Postgresql%20queries%20on%2025%20different%20Excel%20tabs.%26nbsp%3B%20EVERY%20SINGLE%20TIME%20I%20want%20to%20update%20my%20date%20parameter%2C%20it%20asks%20me%2025%20times%20if%20I%20am%20aware%20I%20am%20running%20a%20native%20database%20query.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20someone%20please%20help%20me%3F%26nbsp%3B%20There%20are%20no%20instructions%20anywhere%20on%20how%20to%20do%20this%20in%20Excel%20365...only%20how%20to%20do%20it%20in%20EVERY%20OTHER%20VERSION%20of%20Excel%20that%20has%20ever%20existed.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJoel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-161962%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENative%20Database%20Query%20Warning%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236760%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20Native%20Database%20Query%20Warnings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236760%22%20slang%3D%22en-US%22%3E%3CP%3EOK%2C%20thanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJoel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236539%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20Native%20Database%20Query%20Warnings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236539%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Joel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindly%20follow%20the%20steps%20given%20below%20to%20suppress%20the%20warning%20that%20you%20are%20getting%20%22Native%20Database%20Query%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOpen%20Excel%20-%20Click%20on%20Data%20-%20Get%20Data%20-%20Query%20Options.%20Once%20you%20click%20Query%20Options%20you%20will%20get%20another%20Pop%20up%20Window%20-%20Select%20Security%20-%20You%20will%20get%20Native%20Database%20Queries%20-%20uncheck%20%22Require%20user%20approval%20for%20new%20database%20queries%22%20%26amp%3B%20click%20on%20Ok.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20refer%20to%20the%20screen%20shots%20below%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20967px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43656iD9083E627AADD78B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Query.JPG%22%20title%3D%22Excel%20Query.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20944px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43657i8CE701FE26B515BE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel%20Query%202.JPG%22%20title%3D%22excel%20Query%202.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20764px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43658i538847B39E270F6D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel%20Query%203.JPG%22%20title%3D%22excel%20Query%203.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F43659i83505EAF4156F81E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22excel%20Query%204.JPG%22%20title%3D%22excel%20Query%204.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERobin%20Nishad%3C%2FP%3E%3CP%3ETechnical%20Consultant%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-236492%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20Native%20Database%20Query%20Warnings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-236492%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20here.%26nbsp%3B%20I%20added%20a%20few%20parameters%20tied%20to%20Excel%20cell%20values%2C%20and%20it%20asks%20me%20this%20every%20time.%26nbsp%3B%26nbsp%3BMy%20Excel%20document%26nbsp%3Bwas%20designed%20for%20some%20database-read-only%20people.%26nbsp%3B%20It's%20lame%20that%20they%20have%20to%26nbsp%3Bfreak%20out%20every%20time%20they%20see%20a%26nbsp%3Bbunch%20of%20SQL%20code%20and%20a%20warning%20whenever%20they%20change%20a%20parameter.%26nbsp%3B%20I%20wish%20some%20simplified%20solution%20would%20be%20created%20by%20MS%26nbsp%3Bfor%20using%20cell-originating%20query%20parameters.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1123555%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20Native%20Database%20Query%20Warnings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1123555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F165275%22%20target%3D%22_blank%22%3E%40Robin%20Nishad%3C%2FA%3E%26nbsp%3B%3A%20Since%20this%20is%20a%20Global%20setting%2C%20I'm%20guessing%20this%20only%20applies%20to%20local%20machine%20and%20it%20should%20be%20set%20on%20all%20machines%20that%20will%20open%20the%20workbook%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20so%2C%20anyone%20know%20what%20is%20the%20registry%20key%20and%20what%20it%20should%20look%20like%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1342681%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20Native%20Database%20Query%20Warnings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1342681%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F50322%22%20target%3D%22_blank%22%3E%40Pascal%20Bellerose%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20page%20has%20an%20answer%20about%20RegKeys.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F37186442%2Falways-allow-native-db-queries%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F37186442%2Falways-allow-native-db-queries%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20this%20simple%20set%20of%20screen%20shots!%26nbsp%3B%20Spent%20an%20hour%20looking%20for%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

5 Replies
Highlighted

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.

Highlighted

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 - 

Excel Query.JPGexcel Query 2.JPGexcel Query 3.JPGexcel Query 4.JPG

 

Thanks

 

Robin Nishad

Technical Consultant

Highlighted

OK, thanks.

 

Joel

Highlighted

@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!

Highlighted

@Pascal Bellerose 

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.