Forum Discussion

LondonJim's avatar
LondonJim
Copper Contributor
Dec 05, 2024

SharePoint Regional and Language settings for all sites.

How as global admin or SharePoint Admin do you change the language and regional settings for all Existing SharePoint Online sites and so that new ones have the required setting.  We want en-GB.

 

If this has to be done through a powershell connected script where MFA is enabled I need a script that will run for each site at example contosa.sharepoint.com

Thanks

  • Bright-twist11's avatar
    Bright-twist11
    Copper Contributor

    Hi LondonJim

    I'm linking my post here in case its related. Apologies if it's not.

    https://techcommunity.microsoft.com/discussions/SharePoint_General/default-proofing-language/4349815

  • There are several things here, but first the bad news: there is no way to change the site language setting after the site has been created, and en-gb is not a supported language.  You can choose that setting, but you'll still get en-US.

     

    On to better news.  The site's base language and the site region setting are only defaults, they are used when the user doesn't have a setting.  The user's language setting is in their M365 profile.  If that is not set it will use the browser language.  Provided that the site supports the users language setting, and most sites have at least basic support for all 50 languages unless you remove them, the user will see the site's UI in that language.

    Region settings are a bit different.  Region only affects date and numeric format.  En(GB and en-US differ only in date format.  Again, the user profile can override the site default setting, but only if you check the override setting.

    What can you do as an admin?  If you don't want anyone to see the site UI in any language other than English (en-US) then you can delete all the other languages in the site's language settings in the advanced settings.  If you want users to have a choice, then you can provide their initial settings in their profile using AAD, which syncs with their profile.

     

    • LondonJim's avatar
      LondonJim
      Copper Contributor

      Hi Martin, Thank you for your reply. In this case we need the Language and Region settings as dates in files esp. spreadsheet need to appear in the GB format.  Seen as the sites are already created would it be best to change their profiles to use en-GB language and region format.  Most of our users have already changed their language and region to en-GB but as site set up with default US settings I could only view the correct UK date format by changing the site region to UK.  So the profile region was not over-riding the site region.

      Are you saying the best way to do this would be to make a configuration policy for Edge to use GB region in the browser? That will be another question on how to do that as well as force that for Chrome users.

      Have set the configuration so that the Office Desktop Apps show in the correct date and language when viewed there it is just the browser view that is causing the issue. 

Resources