regedit (GPO) to disable the GroupGetExternalData tab in Excel

h-koga 20 Reputation points


I would like to set regedit (GPO) to disable the 「GroupGetExternalData」 group in Excel.

I want to know the setting location and setting values ​​in regedit (GPO).

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,277 questions
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,447 questions
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,670 questions
0 comments No comments
{count} votes

Accepted answer
  1. Jiajing Hua-MFST 7,545 Reputation points Microsoft Vendor

    Hi @h-koga

    Which version of Office are you using?

    The 'Get External Data' group has been replaced with "Get & Transform Data" group in Excel for Microsoft 365 Apps and other newer versions.

    We are unable to find the corresponding command bar IDs to disable buttons in "Get & Transform Data" group.

    Besides, there is no such GPO policy to disable features of "Get & Transform Data" or Excel Power Query.

    As far as I know, we can disable the external content in Excel workbooks, the reference link is:

    Thanks for your understandings.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful