Trust Center External Data Settings Microsoft Query IQY Files Option Missing - How Can I select it?

Occasional Visitor

I'm having a security issue trying to open an IQY generated from a Sharepoint List export to excel. Help tells me to go File --> Options --> Trust Center --> Trust Center Settings --> External Content and select or deselect this setting: Always block the connection of untrusted Microsoft Query files (.iqy, .oqy, .dqy, and .rqy) 


This option is missing from Trust Center Settings --> External Content.


How do I get this option to appear?

1 Reply


Under File --> Options --> Trust Center --> Trust Center Settings --> File Block Settings it might help to make sure that blocking on Open is not selected for "Microsoft Office Query Files" - or if it is, choose the open to Open selected files in Protected View.