Windows 10: GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016

Discus and support GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016 in Windows 10 Customization to solve the problem; I used the GPO : https://admx.help/?Category=Office2016&Policy=office16.Office.Microsoft.Policies.Windows::L_DisablepasswordtoopenUI I also manually... Discussion in 'Windows 10 Customization' started by GaryOsbourne, Mar 14, 2021.

  1. GARYOSBOURNE
    GaryOsbourne Win User

    GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016


    I used the GPO : https://admx.help/?Category=Office2016&Policy=office16.Office.Microsoft.Policies.Windows::L_DisablepasswordtoopenUI


    I also manually tried this on another test client:

    [COLOR=rgba51, 51, 51, 1]Registry HiveHKEY_CURRENT_USER
    Registry Pathsoftware\policies\microsoft\office\16.0\common\security
    Value Namedisablepasswordui
    Value TypeREG_DWORD
    Enabled Value1
    Disabled Value0[/COLOR]



    But it did not work. Users can still password protect the files. This is causing a great deal of problems, with people leaving the company, etc. Or just multiple users and one password protects an Excel spreadsheet, etc. Does anyone have a suggestion, or even a reason why the GPO doesn't work although I used the latest templates : admintemplates_x64_5140-1000_en-us



    Test client is running 20H2, and the Excel is Version 2102 Build 13801.20294 Click-to-Run

    :)
     
    GaryOsbourne, Mar 14, 2021
    #1
  2. AHHZZ
    Ahhzz Win User

    Office 2019

    Only supported on Win10. Sorry, 8.1 users, only 4 years old, gotta go.

    Microsoft Office 2019 will only work on Windows 10

    https://blogs.technet.microsoft.com...-to-office-and-windows-servicing-and-support/

    Spoiler Office 2019
    Last year at Ignite, we announced Office 2019 – the next perpetual version of Office that includes apps (including Word, Excel, PowerPoint, and Outlook, and Skype for Business) and servers (including Exchange, SharePoint, and Skype for Business). Today we’re pleased to share the following updates:

    • Office 2019 will ship in H2 of 2018. Previews of the new apps and servers will start shipping in the second quarter of 2018.
    • Office 2019 apps will be supported on:
      • Any supported Windows 10 SAC release
      • Windows 10 Enterprise LTSC 2018
      • The next LTSC release of Windows Server
    • The Office 2019 client apps will be released with Click-to-Run installation technology only. We will not provide MSI as a deployment methodology for Office 2019 clients. We will continue to provide MSI for Office Server products.
     
    Ahhzz, Mar 14, 2021
    #2
  3. ANDRE DA COSTA
    Andre Da Costa Win User
    Andre Da Costa, Mar 14, 2021
    #3
  4. CALLENDER
    Callender Win User

    GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016

    EXCELLENT Free Office suite (compatible With Office 2016/2019)

    Hi. Just change the settings. You need to modify all templates.

    GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016 [​IMG]

    GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016 [​IMG]


    GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016 [​IMG]

    You need to modify all of these:



    GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016 [​IMG]
     
    Callender, Mar 14, 2021
    #4
Thema:

GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016

Loading...

  1. GPO to prevent users from Password Protecting Excel files in O365/ Office 2019 and Office 2016 - Similar Threads - GPO prevent users

  2. Office 64-bit version of Word and Excel 2016, 2019, 2012, 0365 Office

    in Windows 10 Gaming
    Office 64-bit version of Word and Excel 2016, 2019, 2012, 0365 Office: Microsoft has introduced into Offices x64 2016, 2019 and 2021 editions an serious issue where they all now start splwow64. On the Desktop this appears not to hinder a user printing but in COM automation all three products Word and Excel compete for splwow64 in a way that...

  3. Office 64-bit version of Word and Excel 2016, 2019, 2012, 0365 Office

    in Windows 10 Software and Apps
    Office 64-bit version of Word and Excel 2016, 2019, 2012, 0365 Office: Microsoft has introduced into Offices x64 2016, 2019 and 2021 editions an serious issue where they all now start splwow64. On the Desktop this appears not to hinder a user printing but in COM automation all three products Word and Excel compete for splwow64 in a way that...

  4. Office 64-bit version of Word and Excel 2016, 2019, 2012, 0365 Office

    in Windows 10 Drivers and Hardware
    Office 64-bit version of Word and Excel 2016, 2019, 2012, 0365 Office: Microsoft has introduced into Offices x64 2016, 2019 and 2021 editions an serious issue where they all now start splwow64. On the Desktop this appears not to hinder a user printing but in COM automation all three products Word and Excel compete for splwow64 in a way that...

  5. Office 2019 Excel Formula

    in Windows 10 Network and Sharing
    Office 2019 Excel Formula: I've installed Windows10 / Office 2019 several months ago... Question regarding MS Excel... Why doesn't the formula A work and my work around formula B does? A ='Account Analysis 21'!C34:G34... B ='Account Analysis 21'!C34+'Account Analysis 21'!D34+'Account Analysis...

  6. Office 2019 Excel Formula

    in Windows 10 Gaming
    Office 2019 Excel Formula: I've installed Windows10 / Office 2019 several months ago... Question regarding MS Excel... Why doesn't the formula A work and my work around formula B does? A ='Account Analysis 21'!C34:G34... B ='Account Analysis 21'!C34+'Account Analysis 21'!D34+'Account Analysis...

  7. Office 2019 Excel Formula

    in Windows 10 Software and Apps
    Office 2019 Excel Formula: I've installed Windows10 / Office 2019 several months ago... Question regarding MS Excel... Why doesn't the formula A work and my work around formula B does? A ='Account Analysis 21'!C34:G34... B ='Account Analysis 21'!C34+'Account Analysis 21'!D34+'Account Analysis...

  8. MS office Excel 2016

    in Windows 10 Network and Sharing
    MS office Excel 2016: How do I apply a new Theme Font to existing workbooks created with another Theme so that all fonts are changed to the new Theme? https://answers.microsoft.com/en-us/windows/forum/all/ms-office-excel-2016/1465ff54-f342-4038-85bf-30d61a970d98

  9. EXCELLENT Free Office suite (compatible With Office 2016/2019)

    in Microsoft Office and 365
    EXCELLENT Free Office suite (compatible With Office 2016/2019): Hi folks For those that don't need or want subscriptions to Office 2016 / 365 etc this suite just keeps getting better and better Downloads - WPS Office Community (Windows Link also on the page) I've found it as pretty well compatible with Ms stuff including .xlsx formats...

  10. Office 2016 users (not 365) / EXCEL print

    in Microsoft Office and 365
    Office 2016 users (not 365) / EXCEL print: Hi folks Office 2016 now apparently is at the same release level as Office 365. Now version 1807. No probs with EXCEL print so perhaps if you had the issue it's fixed by this update. [img] Cheers jimbo 115043