Fix Excel Cannot Save a Copy of an Uploaded OneDrive Workbook
Question details
The user is unable to save a copy of an uploaded workbook using Excel for the Web in OneDrive, receiving an error message despite the file being fully editable and not password-protected.

- Product
- Excel for the Web, Microsoft OneDrive
- Device & OS
- not provided
- Scenario
- Attempting to duplicate or save a copy of an editable workbook hosted on OneDrive using the Excel for the Web interface.
- Observed behavior
- Excel for the web displays the error message 'There was a problem creating a copy of this file' when the 'Save a Copy' command is triggered.
Before troubleshooting, verify that your internet connection is stable and ensure the Excel workbook is fully closed on all other devices and browser tabs to prevent file locking conflicts.
Clear Browser Cache and Revoke User Sessions
Resolve browser-related glitches or stale session conflicts that are preventing Excel for the Web from duplicating the file.
This issue is frequently caused by stale cached data in your web browser or lingering SharePoint Online sessions that lock the file in the background.
Close the problematic workbook in all browsers, tabs, and on any other devices where it might be open.
Open your browser's settings menu, navigate to the privacy or history section, and clear your browsing data (specifically cache and cookies).
Completely close and restart your web browser, log back into OneDrive, and attempt to use the 'Save a Copy' feature again.
If the error persists, contact your Microsoft 365 administrator and request them to revoke your stale SharePoint Online user sessions. Wait a few minutes before trying again.

Duplicate the File via File Explorer Using OneDrive Sync
Bypass the web browser entirely by copying the file locally using the OneDrive desktop sync client.
Upload a Copy from Your Local Computer
Use the original local source file to manually create duplicates and upload them directly to a private OneDrive folder.
Try WPS Office for Seamless Spreadsheet Management
If you are experiencing frequent cloud syncing or saving errors with Excel for the Web, consider switching to WPS Office. It provides a robust, lightweight desktop and cloud experience without the hassle of stale web sessions.
- 1. Download and Install: Download WPS Office for free from the official website and complete the quick installation.
- 2. Open your Spreadsheet: Launch WPS Spreadsheet and easily open your local or cloud-based Excel files.
- 3. Save effortlessly: Edit your workbook and use the straightforward 'Save As' feature to securely store copies anywhere you need.

Frequently Asked Questions
Why does Excel for the Web display a 'problem creating a copy' error?
This error is typically triggered by a stale browser cache, conflicting user sessions in SharePoint Online locking the file, or temporary server synchronization issues within Microsoft OneDrive.
Can password protection cause files to fail when saving a copy online?
Yes, password-protected workbooks have restricted functionality in Excel for the Web and often cannot be copied or edited seamlessly in the browser. However, if your file isn't password-protected, the issue is likely session-related.
How can I revoke stale SharePoint Online user sessions?
Revoking user sessions must be done by a Microsoft 365 administrator. They can log into the Microsoft 365 admin center, select the specific user account, and use the option to sign the user out of all active Microsoft 365 sessions.
Is it better to copy files in the web browser or File Explorer?
Copying files directly through File Explorer using the OneDrive desktop sync client is generally more reliable and faster, as it bypasses web browser caches and server-side session conflicts entirely.




