How to Duplicate an Excel Document on Windows Safely

How-to basics · Updated November 20, 2026

To duplicate an Excel document on Windows, open it in Excel and choose File > Save As > Browse, then save it under a different name or in a different folder. The original stays in place, and Excel opens the new copy so you can continue working on it. You can also copy and paste the workbook in File Explorer if you want to duplicate the file without opening Excel.

Use Save As when you want a separate working version and a clear new filename; use File Explorer when you simply need an additional copy of the file. The steps below apply to Microsoft Excel for Microsoft 365 on Windows. A duplicate workbook is a separate file, while a duplicate worksheet is another tab inside the same workbook—those are different tasks.

What You’ll Need

  • A Windows PC with Microsoft Excel installed, if you plan to use Save As. File Explorer copying does not require Excel to be open.
  • The workbook you want to duplicate, and permission to access its current folder.
  • A destination folder with enough free space. If you want to keep the source and copy together, make sure you can give the copy a distinct filename.
  • If the workbook is stored in OneDrive or SharePoint, an internet connection may be needed to sync the copy. You can also use a local folder if you need an offline copy.

Step-by-Step

  1. Find the workbook and decide what kind of copy you need. Locate the Excel file in its folder or open it from Excel. Decide whether the copy should sit next to the original or in a separate folder, such as a dated archive or a project folder. Also decide whether you need a complete file copy or only a duplicate worksheet. For a full document copy, continue with one of the methods below.
  2. Save any unsaved changes in the original first. If the workbook is open and contains edits you want in the duplicate, press Ctrl+S. Check the title bar or the AutoSave indicator if you use OneDrive; wait for saving or syncing to finish before making the copy. Otherwise, the duplicate may reflect an earlier saved version instead of the changes currently visible on screen.
  3. Choose the Excel Save As method for a working copy. In Excel, select File > Save As. If Excel shows a list of locations or recent folders, select Browse to open the Windows Save As dialog. In some Microsoft 365 layouts, Browse appears below or alongside the suggested locations. The exact list can differ according to your account and whether the workbook is stored locally or in the cloud.
  4. Select the destination folder. In the Save As dialog, navigate to the folder where the duplicate should live. For example, choose Documents > Project Copies, or select a OneDrive folder if the new copy should sync across your devices. Confirm the location shown in the dialog before saving. If you choose the same folder as the source, you must use a different filename or Excel will ask whether to replace the existing file.
  5. Give the copy a distinct, recognizable name. Enter a new name in the File name box, such as Quarterly-Report-Working-Copy.xlsx or Inventory-2026-11-03.xlsx. A date or purpose can help you tell versions apart later. Do not remove the file extension unless you know which format you need. Excel usually adds the correct extension based on the selected file type.
  6. Check the file type before saving. For most standard workbooks, keep Excel Workbook (*.xlsx). If the original contains macros, it may use Excel Macro-Enabled Workbook (*.xlsm); choose that format to preserve VBA macros. If you select .xlsx for a macro-enabled workbook, Excel warns that macros cannot be saved in that format. Choose the macro-enabled format if you need those macros in the copy. Other formats, such as CSV, do not preserve all workbook features, sheets, formatting, or formulas.
  7. Save the duplicate and confirm Excel has switched to it. Select Save. Excel saves a new file at the destination and typically makes that copy the active workbook. Look at the title bar to confirm the new filename. The original remains unchanged, provided you used a different name or folder. If Excel displays a format warning, read it and choose the option that keeps the features you need.
  8. Check the copy before editing or sharing it. Confirm the expected filename and folder, then inspect important sheets, formulas, charts, and links. If the workbook uses external data or linked files, check whether those connections still point to the intended locations. Close and reopen the duplicate if you want to verify that it was saved correctly. Keep the original until you know the new file is complete.

Alternative: duplicate the file in File Explorer. Close the workbook in Excel first if possible, especially if it is stored on a shared drive or being edited by someone else. Open File Explorer with Windows key+E, browse to the workbook, select it, and press Ctrl+C. Open the destination folder and press Ctrl+V. Windows creates a separate copy, usually with a name that includes Copy; the exact suggested name can vary. Rename it with F2, type a clear filename, and press Enter. If the copy should go in the same folder, paste there and make sure the new name is distinct. You can then open the duplicate in Excel. Do not choose Replace if you meant to preserve an existing file with the same name.

Common Mistakes

  • Using Save instead of Save As. Ctrl+S updates the currently open file; it does not create a separate workbook. Use File > Save As when you want a distinct copy. After Save As, remember that Excel usually has the new copy open, so later Ctrl+S saves changes to the copy.
  • Overwriting the source by reusing its name. If you choose the original folder and keep the exact same filename, Windows or Excel may ask whether to replace the file. Cancel if you want to keep both versions, then choose another name or destination.
  • Copying an unsaved version. File Explorer copies what is saved on disk, not edits that exist only in an open Excel window. Save first, or use Save As from Excel after saving the changes you want included.
  • Changing the file format accidentally. Saving a workbook as CSV or an older Excel format can remove or alter features. In particular, .xlsx does not store VBA macros. Keep the original format unless you have a specific reason to convert.
  • Assuming a worksheet tab is a separate file. Copying a sheet within a workbook does not create a second workbook on your computer. If you need a separate document, use Save As or File Explorer.
  • Editing the wrong version afterward. The title bar shows which workbook is active. Give copies clear names, and check the title before making important changes or sending a file.

Tips

  • Use names that explain purpose and date. For example, Budget-Review-2026-11-03.xlsx is easier to identify than Copy of Budget.xlsx. Use a consistent date style so files sort in a predictable order.
  • Keep a clean original. Store a reference copy in a dedicated folder and make working copies elsewhere. This makes it less likely that routine edits will change the source you intended to preserve.
  • Prefer Save As for a copy based on the open workbook. It reduces the chance of copying an older saved state from disk and makes the new filename visible in Excel right away.
  • Use File Explorer for a simple file-level duplicate. This can be convenient when Excel is not open or when you want to copy several files. Select multiple workbooks with Ctrl-click, then use Ctrl+C and Ctrl+V.
  • Be deliberate with cloud folders. A file saved in OneDrive or SharePoint may sync to other devices or be available to collaborators, depending on its location and sharing settings. For a private local copy, choose a folder on the PC that is not inside a synced folder.
  • Remember that a duplicate is not automatically a backup. If both files are in the same folder or on the same drive, a drive failure or accidental deletion could affect both. For important workbooks, keep a separate backup in another location.

Troubleshooting

Excel says the file already exists. You have selected a name and location already in use. Choose Cancel or No if you do not want to replace that file, then add a date or a label such as Working Copy to the filename, or select another folder. Only confirm replacement if you are certain the existing file can be overwritten.

The duplicate is missing recent edits. Open the original and check whether there are unsaved changes or a sync warning. Save the original and wait for OneDrive or SharePoint to finish syncing, then create the copy again. If you already made a duplicate, use Save As again with a new name so you do not overwrite the first copy until you have checked it.

Excel warns that some features cannot be saved. Check the file type shown in the Save As dialog. If the original is .xlsm and the copy needs its macros, select Excel Macro-Enabled Workbook (*.xlsm). If you save as .xlsx, macros are not retained. For other warnings, decide whether the named feature matters before choosing to continue.

You cannot save to the selected folder. Choose another folder where you have permission, such as Documents, or ask the folder owner or administrator for access. A network location may be disconnected, unavailable, or read-only. If you save locally first, you can move the file to the shared location later when access is restored.

File Explorer will not copy or rename the workbook. Close it in Excel and check that no other person or program is using it. Confirm that the destination is not full or read-only and that the filename does not contain characters Windows disallows, such as a colon or question mark. Try a shorter name and a local destination to identify whether the issue is the path or the shared folder.

The copy opens read-only or shows a sync conflict. Check the file’s Properties in File Explorer and confirm that the Read-only attribute is not selected if you need to edit it. For a cloud or shared workbook, wait for sync to complete and check whether another person has the file open. Save your edits to a new filename rather than overwriting a version you cannot confidently identify.

Frequently Asked Questions

Does Save As change the original Excel file?
Not when you save under a different name or in a different folder. Excel creates a separate file and usually switches to that new copy. The original stays as it was at the time the copy was made.

Can I duplicate an Excel workbook without opening Excel?
Yes. Use File Explorer: select the file, press Ctrl+C, open the destination folder, and press Ctrl+V. Rename the copied file if needed. This copies the last version saved to disk, so it will not include unsaved edits.

How do I make a copy in the same folder?
Use Save As and enter a different filename, or copy and paste the workbook in File Explorer. Do not give the copy the same name and extension as the original in that folder; Windows cannot keep two files with the same full name in one location.

How do I duplicate just one worksheet?
Right-click the worksheet tab, select Move or Copy, choose the destination workbook or the current workbook, check Create a copy, and select OK. This makes another sheet tab; it does not create a separate Excel document. Menu wording can vary slightly in some Excel builds.

Will a duplicated workbook keep macros and links?
A file-level copy normally carries the workbook contents, including formulas and links. To retain VBA macros, keep the workbook in .xlsm format. External links may still refer to the same source files after copying, so check them if the duplicate is meant to work independently.

Can I duplicate a workbook in Excel for the web?
Yes, but the controls differ from Windows desktop Excel. In Excel for the web, use File > Save As and choose Save a Copy when available, then select a name and location. The copy is stored online, and available options depend on your OneDrive or SharePoint permissions.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.