Native DB Query Prompt - when sharing workbook

[MI_2016]

Hi There

I have a workbook which uses Power Query.

I have tried the various suggestions I have found online for disabling the Native DB Query security prompts which seem to work when I refresh the workbook on my machine. However when the workbook is shared with other users it seems to ignore these settings and still prompts the user with the Native Database Query security prompts for each connection in the workbook.

Are these settings user specific? if so is there a way anyone knows of to globally set these prompts not to be shown?

Many Thanks

 

[VBA Geek]

Each user needs to change the setting on her machine