Use VBA to Disable PQ Preview in Background

[AllisterB]

Hi

I want to ensure that users of my Excel Workbook have "Allow data previews to download in the background"disabled.

I intend to l run VBA as part of the On open macro.

I also want the Privacy setting for the workbook to be set to Ignore Privacy settings.

How would one go about this with VBA.

Thank You

Allister

[XLent]

Hi, yes, the "file" Privacy setting is set per client so, modifying in the Open event makes sense if enforcing standards across all clients using the file
(obviously, you need to be confident this isn't creating any security issues, given you're ignoring the privacy setting wherever the file is opened)

Please Login or Register  to view this content.

w.r.t the Preview, I've not tested to see if it behaves the same way as the above but, you could embed further code as outlined in the below link so as to disable the preview:

https://www.excelcampus.com/vba/enab...y-connections/

there are other more educated PQ folk here who may correct the above and/or offer alternatives, of course