通过VBA修改数据隐私级别 [英] Modify Data Privacy Levels via VBA

问题描述

如何通过VBA修改数据隐私级别?

How do I modify Data Privacy levels via VBA?

即我有一本工作簿，需要允许在所有用户的计算机上刷新，但是我不希望他们单击​​选择隐私级别"选项.

i.e. I have a Workbook which needs to allow refreshing on all users' computers, however I do not want them to have to click past the "Choose Privacy Level" option.

工作簿是通过VBA生成的，所以我想通过VBA禁用新工作簿的隐私级别(因此，当打开并刷新该工作簿时，隐私级别不会弹出吗?)

The workbook is generated via VBA, so I want to disable privacy levels for the new workbook via VBA (so when it is opened and refreshed the privacy level does not pop up?)

推荐答案

尝试使用:

ThisWorkbook.Queries.FastCombine = True

快速合并将工作簿设置为忽略每个来源的隐私级别-它适用于工作簿的所有用户.

Fast Combine sets the workbook to ignore the privacy levels for each source - and it applies to all users of the workbook.

此处提供更多信息: 查看全文