Formatting Issues

How to Fix Excel Changing Fonts and Formatting in OneDrive Files

WPS Content Manager Oct 10, 2026 869 views

Question details

Users experience unexpected formatting changes, such as altered fonts, dates, and numbers, specifically on the first active worksheet when opening Excel 365 files stored in OneDrive.

How to Fix Excel Changing Fonts and Formatting When Opening OneDrive Files

Product: Microsoft Excel 365, OneDrive
Device & OS: not provided
Scenario: Opening and viewing Excel workbooks synced or stored in Microsoft OneDrive.
Observed behavior: Excel automatically changes the fonts, dates, numbers, and other formatting on the worksheet that opens first, regardless of which sheet was active when the file was last saved, while subsequent sheets remain unaffected.

Before you start

Verify whether this formatting issue occurs only in Excel for the Web, the Excel desktop application, or both, as this will help narrow down whether the root cause is cloud rendering or local application settings.

Solution 1Recommended

Test the Excel File Locally to Isolate the Issue

Downloading the file helps determine if the issue is caused by OneDrive syncing conflicts or your local Excel environment.

By taking OneDrive out of the equation, you can test if the document itself is corrupted or if the cloud synchronization process is causing the formatting changes upon launch.

Download from OneDrive

Open OneDrive online in your browser, locate the affected Excel workbook, right-click the file, and select 'Download' to save a local copy to your computer's hard drive.

Open the Local File

Launch the Excel desktop app, navigate to File > Open, and select the newly downloaded local copy.

Verify Formatting

Check the first opened worksheet to see if the fonts, dates, and numbers have retained their original formatting.

Test the Excel File Locally to Isolate the Issue

Environment Check: If the local file opens correctly without formatting changes, the issue is directly related to OneDrive sync or Excel for the Web.

Solution 2

Check Excel Regional Settings and Default Fonts

Ensure that your local Excel and system settings are not overriding the document's original formatting upon opening.

Solution 3

Escalate to Microsoft Support or IT Administrator

Since the issue affects multiple workbooks and every file opened from OneDrive, it likely requires an environment-level investigation.

Free Microsoft Office alternative

Try WPS Office for Stable and Reliable Spreadsheet Formatting

If Excel continues to corrupt your formatting when syncing with OneDrive, consider switching to WPS Office. It offers a lightweight, highly compatible spreadsheet tool that reliably preserves your fonts, dates, and data formats without unexpected cloud-sync glitches.

1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install WPS Office: Run the downloaded installer and follow the on-screen prompts to set up the software on your device.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your .xlsx files to enjoy stable formatting and seamless editing.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Stable local and cloud file handling that prevents unexpected formatting changes.Lightweight design that loads complex workbooks faster than traditional heavy office suites.Free to use with a familiar tabbed interface, requiring zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change my dates and numbers format automatically?

This often occurs due to conflicting regional settings between your computer, the Excel application, and the cloud environment (like OneDrive). Excel may automatically attempt to adjust dates and numbers based on the detected system locale.

How can I stop OneDrive from changing my Excel file formatting?

You can mitigate this by pausing your OneDrive sync temporarily, downloading the file directly to your hard drive, or ensuring you open the file exclusively in the Excel desktop application rather than Excel for the Web.

Can third-party add-ins cause Excel formatting to change unexpectedly?

Yes, certain COM add-ins can conflict with Excel's rendering engine. You can test if this is the cause by launching Excel in Safe Mode (hold the Ctrl key while opening the app) to see if the formatting issue persists.

Document & File Issues