How to Fix the SharePoint Online Windhoek Time Zone Mismatch
Question details
The user needs to correct a timezone discrepancy for Windhoek, where SharePoint Online displays an incorrect offset compared to the rest of Microsoft 365.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Configuring regional settings to ensure consistent timestamps across collaborative cloud environments.
- Observed behavior
- SharePoint Online incorrectly shows Windhoek as UTC+01:00, whereas Microsoft 365 displays the correct UTC+02:00 setting, leading to inconsistent timestamps across the platform.
Ensure you have SharePoint Administrator privileges and access to the SharePoint Online Management Shell before attempting to modify regional settings via command line.
Enforce the Correct Time Zone via SharePoint PowerShell or CSOM
Use SharePoint PowerShell or the Client-Side Object Model (CSOM) to bypass the flawed UI and programmatically apply the correct UTC+02:00 time zone.
The differing time-zone entries are due to a known issue in the SharePoint Online user interface. While Microsoft 365 has updated the Windhoek timezone to UTC+02:00, SharePoint Online may still display the outdated UTC+01:00 in its frontend settings.
To work around this interface glitch, administrators can enforce the correct time zone configuration using automation scripts, ensuring accurate timestamps across sites.
Launch the SharePoint Online Management Shell on your computer with Administrator privileges.
Execute the command `Connect-SPOService -Url https://yourdomain-admin.sharepoint.com` and log in with your administrative credentials.
Reference the Microsoft `SPRegionalSettings.TimeZones` documentation to find the exact numerical ID corresponding to the GMT+02:00 Windhoek time zone.
Write and execute a CSOM or PowerShell script to loop through the affected site collections and update the `RegionalSettings.TimeZone` property to the correct ID.
Experience a Seamless and Lightweight Office Alternative
Troubleshooting complex backend regional settings in Microsoft 365 and SharePoint can be frustrating. Simplify your daily document workflow with WPS Office, a highly compatible, fast, and free alternative for all your productivity needs.
- 1. Download the Installer: Visit the official WPS website and download the free installer for your operating system.
- 2. Install WPS Office: Run the setup file and follow the quick on-screen instructions to complete the installation.
- 3. Open Your Documents: Launch WPS Office and instantly open your existing Microsoft Office documents without worrying about format conversion or cloud configuration errors.
Frequently Asked Questions
Why does SharePoint Online show a different time zone for Windhoek than Microsoft 365?
This happens due to an outdated regional settings database within the SharePoint Online user interface. While the main Microsoft 365 environment has been updated to UTC+02:00, the SharePoint UI still reflects the old UTC+01:00 setting.
Will this timezone mismatch affect my document modification dates?
Yes. Because SharePoint relies on its regional settings to display metadata, an incorrect timezone will cause document modification timestamps and calendar events on your SharePoint sites to appear offset by one hour.
Can I fix this timezone issue directly through the SharePoint admin center UI?
Usually, no. Because the UI itself contains the flawed data entry for Windhoek, selecting it might revert to the incorrect offset. Administrators must use PowerShell or CSOM to apply the proper timezone settings directly to the backend.
