Others

Fix SharePoint Currency Column Multiplying Values by Ten

Maira Mehtab Sep 20, 2026 868 views

Question details

Users need a permanent solution or workaround for a SharePoint bug that incorrectly multiplies currency values.

Product: SharePoint
Device & OS: not provided
Scenario: Entering financial or numerical data into a SharePoint list using a configured currency column.
Observed behavior: Values entered into the currency column are automatically multiplied by ten after a few seconds (e.g., 400 changes to 4000). This persists across multiple lists, browsers, users, and devices, and clearing cookies only provides temporary relief.

Before you start

Ensure you have List Owner or Site Administrator permissions in SharePoint to access and modify the Advanced Settings of the affected list.

Solution 1Recommended

Disable Offline Client Availability

This temporary workaround stops the incorrect multiplication behavior by disabling the offline caching feature that triggers the bug.

Since this behavior is an environment-wide bug affecting multiple lists and users, applying a local client fix like clearing cookies will only work temporarily. Modifying the list's offline settings provides a more stable workaround while waiting for Microsoft to resolve the root cause.

Access List Settings

Navigate to your affected SharePoint list, click the Gear icon in the top right corner, and select 'List Settings'.

Open Advanced Settings

Under the General Settings column, click on 'Advanced Settings'.

Disable Offline Availability

Scroll down to the 'Offline Client Availability' section and change the toggle to 'No'.

Clear Browser Cookies

Save your changes and clear your browser cache and cookies to ensure the new list settings take effect immediately.

Escalate to Microsoft Support

Contact your Microsoft 365 administrator and request that they open an official service request with Microsoft so the development team can investigate your tenant's issue.

System-Wide Bug: Because this affects multiple devices and users, the ultimate resolution must come from a Microsoft patch. Always report widespread anomalies to your IT admin.

Free Microsoft Office alternative

Manage Financial Data Reliably with WPS Office

If SharePoint bugs are disrupting your data entry workflow, consider managing your financial spreadsheets offline or locally using WPS Spreadsheet. WPS Office is a robust, free alternative to Microsoft Office that ensures your data remains exactly as you format it, without unexpected syncing errors.

1. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
2. Export SharePoint List: Export your current SharePoint list to an Excel format.
3. Manage Data in WPS Spreadsheet: Open the exported file in WPS Spreadsheet to manage your currency columns accurately without sync bugs.

Fully compatible with Microsoft Excel (.xlsx) formatsNo unexpected automatic value multiplications or cloud syncing glitchesLightweight, fast, and completely free to useFamiliar user interface makes migration seamless

Frequently Asked Questions

Why is my SharePoint currency column multiplying values by ten?

This is typically caused by a known syncing or client-side caching glitch in Microsoft 365 related to offline client availability, which forces a miscalculation when data is committed to the server.

Will clearing browser cookies permanently fix the SharePoint currency bug?

No. Clearing cookies only forces the browser to pull fresh data, temporarily resolving the issue. The bug often returns until the list's offline client availability is disabled or Microsoft applies a patch.

How do I report this bug to Microsoft?

You need to contact your organization's Microsoft 365 administrator. They have the proper permissions to log into the Microsoft 365 admin center and open a formal service request directly with Microsoft support.

Office Quick Solutions