'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel for Web Date Format and Support Access Errors
Question details
The user is experiencing persistent US date formats in Excel for the web and encountering an "Access Denied" error when trying to contact Microsoft Support with an active Microsoft 365 subscription.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Attempting to apply regional date formatting in a web spreadsheet and trying to access customer support for troubleshooting assistance.
- Observed behavior
- Dates remain stuck in the US format regardless of user settings, and the Microsoft Support portal displays an "Access Denied" error message.
Ensure you have your Microsoft 365 subscription login credentials handy and verify that your internet connection is stable before attempting network or browser troubleshooting.
Check Microsoft 365 Service Health and Contact Support Later
Since the date format bug and the support portal errors are known issues, checking server health is the best first step.
Both the persistent US date formatting in Excel for the web and the 'Access Denied' error are known issues currently under investigation by Microsoft's development team.
These behaviors are frequently caused by temporary server outages or syncing bugs within the Microsoft 365 cloud environment.
Go to the official Microsoft 365 Service health status page to see if there are any ongoing outages reported for Excel for the web or Microsoft support services.
Wait for a few hours if an active outage is indicated on the dashboard, then attempt to access the Microsoft Support page again.
Have your Microsoft 365 subscription details and account email ready to provide to the support agent once the portal becomes accessible.
Troubleshoot Browser and Network Issues
Clear potential local cache or network routing issues that might cause the 'Access Denied' support error.
Switch to WPS Office for Reliable Desktop Spreadsheets
If you are tired of cloud service outages and regional formatting bugs in Excel for the web, WPS Office offers a powerful, reliable desktop alternative. It is completely free, lightweight, and highly compatible with Microsoft Excel formats, ensuring your dates format exactly the way you want them without relying on a web server.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official website to your computer.
- 2. Open your Excel file: Launch WPS Spreadsheets and click 'Open' to load your existing Microsoft Excel (.xlsx) files directly.
- 3. Apply local date formats: Select your date cells, right-click, and choose 'Format Cells' to easily set your preferred regional date format without web syncing errors.
Frequently Asked Questions
Why does Excel for the web keep changing my dates to US format?
This is currently a known bug in Microsoft Excel for the web where regional date settings are overridden by the US format. Microsoft's development team is actively investigating this server-side issue, and it usually resolves once they patch the cloud environment.
Why am I getting an Access Denied error on Microsoft Support with an active subscription?
The Access Denied error is typically caused by temporary Microsoft server issues, outdated browser cache, or network configuration problems blocking the authentication of your Microsoft 365 subscription. Trying a different browser or network often resolves it temporarily.
How can I change the regional format settings in Excel for the web?
You can normally change this by going to File > Options > Regional Format Settings in Excel for the web. However, if the known formatting bug is active, these settings may temporarily fail to apply correctly until the server issue is fixed.
