Forum Discussion
Joel Harmon
Feb 20, 2018Copper Contributor
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 ...
Rnishat0786
Aug 23, 2018Iron Contributor
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
Joel Harmon
Aug 24, 2018Copper Contributor
OK, thanks.
Joel