OneDrive File Issues

How to Copy an Excel Workbook in OneDrive Without Losing Formatting

Maira Mehtab Sep 28, 2026 870 views

Question details

The user wants to duplicate an existing Excel workbook stored in OneDrive without losing any of the file's original formatting or data.

Product: OneDrive / Microsoft Excel
Device & OS: not provided
Scenario: Creating a backup or a duplicate copy of an Excel spreadsheet directly within cloud storage.
Observed behavior: The user needs to successfully create an exact replica of the workbook where all cell styles, layouts, and data remain entirely intact.

Before you start

Ensure you are logged into your OneDrive account in your web browser or file explorer and have sufficient storage space available for the duplicated workbook.

Solution 1Recommended

Copy the Workbook Directly Using OneDrive

Use OneDrive's built-in file duplication options to securely create a copy of your workbook without affecting its internal formatting.

Duplicating the file directly through OneDrive's interface ensures that you are making an exact clone of the original document. This avoids the common formatting loss associated with manually copying and pasting cell data between open workbooks.

Select the Workbook

Navigate to your OneDrive folder and locate the Excel workbook you want to duplicate. Click the checkmark circle or simply click on the file to select it.

Choose the Copy Command

Click on the 'Copy to' option located in the top menu bar. Alternatively, you can right-click the file and select 'Copy to' from the context menu.

Select Destination and Copy

In the pane that appears, navigate to and select the destination folder where you want the new copy to be saved, then click the 'Copy Here' button.

Keep Both Files

If you are copying the file into the same folder, OneDrive may prompt you about a file name conflict. Choose 'Keep both' to generate a duplicate without overwriting the original.

Rename the Copied Workbook

Locate the newly copied file, right-click it, select 'Rename', and give it a distinct name to help you easily identify it from the original.

Formatting Maintained: Because you copied the entire file rather than the contents inside the spreadsheet, 100% of your formatting, charts, and macros remain intact.

Free Microsoft Office alternative

Use WPS Office for Effortless Spreadsheet Management

If you frequently work with complex spreadsheets, WPS Office offers a free, lightweight, and highly capable alternative to Microsoft Office. It allows you to seamlessly edit, copy, and manage your spreadsheets with absolute precision.

1. Download WPS Office: Visit the official WPS website, download the free suite, and follow the quick installation prompts.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open any existing Excel workbook. You will see that all your original formatting is perfectly displayed.
3. Save to WPS Cloud: Click 'Save As' and select 'WPS Cloud' to safely store your documents online, making it incredibly easy to copy or share them across any device.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Guarantees that all complex formatting, formulas, and charts are perfectly preserved.Includes built-in WPS Cloud storage for easy file duplication and backup.Completely free, lightweight, and features a familiar tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel file sometimes lose formatting when copying?

Formatting loss typically occurs when you open a workbook, highlight cells, and copy/paste them into a new file as plain text or values. Copying the file itself directly in your file explorer or OneDrive prevents this entirely.

Can I copy an Excel workbook from OneDrive to my local computer?

Yes. Select the workbook in your OneDrive online interface, click 'Download' from the top menu, and a copy of the file will be saved to your computer's local hard drive with all formatting intact.

How do I duplicate just one specific worksheet rather than the entire workbook?

Open the workbook, right-click the specific sheet tab at the bottom of the window, and select 'Move or Copy'. Check the box for 'Create a copy', select your destination, and click OK.

Document & File Issues