Save an Excel File as a Copy: Step-by-Step Instructions

How-to basics · Updated November 20, 2026

To save an Excel file as a separate copy in Microsoft 365 for Windows, open the workbook and select File > Save As > Browse, then choose a different folder or enter a new file name and select Save. The original remains available, but Excel may switch to the new file afterward. For a workbook stored in OneDrive or SharePoint, you may also see File > Save a Copy. Make sure you check which file is open before continuing to edit.

Making a copy gives you a separate workbook to edit, share, or keep as a backup without deliberately overwriting the source file. The steps vary slightly for local files, cloud workbooks, Mac, and Excel for the web, so use the section that matches where you have opened the file.

What You’ll Need

  • The workbook you want to copy, open in Excel or available in a folder you can access.
  • A destination folder or cloud location with permission to save files.
  • A new file name if you want to distinguish the copy from the original. Keep the appropriate file extension, such as .xlsx or .xlsm.

Step-by-Step

  1. Open the source workbook. In Excel, open the file you intend to duplicate. If you have several similarly named workbooks or browser tabs open, check the workbook title and, if needed, use File > Info to confirm the file and location. If the source has unsaved changes, decide whether those changes should be included. Saving a copy from the open workbook normally includes its current changes.
  2. Choose the copy method for your file. For a file saved on your computer or a network drive, use File > Save As. For a workbook stored in OneDrive or SharePoint, check File for Save a Copy; depending on the account, permissions, and interface, this option may be available instead of or alongside Save As. These commands have similar goals, but the screens and destination choices can differ.
  3. Open the Save As dialog in Excel for Windows. Select File > Save As > Browse to open the Windows file dialog. If your Excel version displays a different Save As screen, select Browse or This PC to get to the folder picker. You can also press F12 in Excel for Windows to open Save As. Do not choose Save by itself: that updates the currently named workbook rather than creating a differently named file.
  4. Select where the copy will go. In the dialog, navigate to a different folder if you want the copy stored separately. You can save it beside the original, but choose a clear name so the two files are easy to tell apart. For cloud storage, select an available OneDrive or SharePoint location and make sure you have permission to create a file there.
  5. Enter a distinct file name. Click the File name box and type the name for the copy. For example, if the source is Quarterly Budget.xlsx, you might name the copy Quarterly Budget – review.xlsx. Excel generally supplies the extension based on the selected file type. Avoid typing a second extension if Excel has already added one, which could produce a confusing name such as review.xlsx.xlsx.
  6. Check the file type and save. In Save as type, keep the original format in most cases. An .xlsx workbook is a standard Excel workbook; an .xlsm file can contain macros. If Excel warns that a feature is not supported in the selected format, stop and choose a compatible format if you need to preserve that feature. Select Save to create the copy.
  7. Confirm the copy exists and identify the open workbook. Check the title bar for the name now shown in Excel. Then, if you need to be certain, use File > Open or File > Info to check the location, or look in the destination folder and confirm that both files are present. Save As commonly makes the new file the active workbook. If you want to continue working in the original, reopen it from its original location.
  8. Use the corresponding option on Mac or the web. In Excel for Mac, use File > Save As, choose a name and location in the dialog, and save; the precise dialog layout can vary by macOS and Excel version. In Excel for the web, use File > Save As > Save a Copy when that command is available, then choose the offered destination and name. To make a local copy from the web, use Download a Copy if it appears in the Save As menu. Afterward, check the displayed workbook name or your downloads folder to make sure you are editing or opening the intended copy.

After the copy is saved, changes made to one workbook do not automatically update the other. Treat them as separate files, and avoid giving both files the same name in the same folder: a save dialog may ask whether you want to replace an existing file.

Common Mistakes

  • Using Save instead of Save As. Save updates the open file under its existing name and location. To create a separately named workbook, use Save As or Save a Copy, then confirm the destination and name.
  • Assuming the original is still active. After Save As, Excel often switches to the newly named copy. A later Ctrl+S can therefore save changes to the copy, not the source. Check the title bar and reopen the source if that is where you mean to work.
  • Saving over the source by accident. If the new file uses the same name in the same folder, Excel may prompt you to replace the existing workbook. Cancel if you did not intend to overwrite it, then change the name or folder.
  • Changing the file format without noticing. Saving a macro-enabled workbook as .xlsx can remove macros. Keep .xlsm when the workbook needs its VBA macros, and heed Excel’s compatibility warnings rather than dismissing them automatically.
  • Confusing a shortcut with a copy. A desktop shortcut or a shared link points to a file; it is not a second, independent workbook. Use Save As, Save a Copy, or Download a Copy to create a separate file.
  • Thinking the two workbooks stay synchronized. A copy is independent. Edits, formulas, and new rows in one file do not flow into the other unless you deliberately copy or synchronize data.

Tips

  • Use a naming pattern that records purpose or date, such as Sales Report – draft or Sales Report – 2026-11-03. Put the date in a consistent format so versions sort clearly.
  • Store the copy in a folder that makes its role obvious, such as Drafts, Archive, or Review. A good name and location reduce the chance of editing the wrong version later.
  • If your goal is to preserve a clean original, make the copy before making substantial changes. Then reopen the original and avoid editing it until you are ready.
  • Keep the original extension unless you have a reason to convert formats. In particular, preserve .xlsm for macro-enabled workbooks and check warnings before saving to another format.
  • For OneDrive or SharePoint files, wait for the save or sync indicator to finish before closing Excel. If you have access to version history, it can provide another way to recover an earlier state, but it is not a substitute for a clearly named independent copy.
  • When sending the copy to someone else, verify that you are attaching the copy rather than the source. Open the destination folder or use the attachment picker to check the exact filename before sending.

Troubleshooting

Save As or Save a Copy is missing. In the Windows desktop app, start with File > Save As and look for Browse or This PC. If the workbook is cloud-hosted, check the File menu for Save a Copy, or use Save As and select a destination. In a browser, the available commands can depend on whether the workbook is opened in Excel for the web, your organization’s settings, and your permissions. If you cannot create a copy there, use the desktop app or ask the file owner for access.

Excel says the workbook is read-only or you do not have permission. You may be able to save a separate copy to a folder where you have write access, even when you cannot change the source. Choose a personal or approved destination and do not try to bypass your organization’s access controls. If no destination is available, contact the owner or administrator.

The copy is not in the folder you expected. Check the destination shown in the Save As dialog and search your computer for the new filename. For a web download, check the browser’s downloads list and the default Downloads folder. Cloud copies may be saved to a selected OneDrive or SharePoint folder rather than your computer.

The workbook opens with the old name or you cannot tell which one you saved. Close or switch away from the workbook, then open the file from the folder or cloud location you selected. Confirm its name in Excel’s title bar. If both files have similar names, rename the copy with a clear label, taking care not to overwrite either one.

Excel warns that some features may be lost. Cancel the save and check the file type. Choose the original format where possible, especially if the workbook uses macros, special formatting, or features that another format may not support. If you must create a different format for sharing, keep an Excel-format copy as well.

Frequently Asked Questions

Does Save As change the original Excel file?
It creates a file with the name and location you choose. In desktop Excel, the newly saved file often becomes the active workbook, but the original remains unchanged unless you save over it separately.

What is the difference between Save As and Save a Copy?
Both can create a separate workbook. Save As is the standard choice for local files and lets you choose a name, location, and format. Save a Copy is commonly offered for cloud-stored workbooks and can have a different screen or workflow. Check the resulting filename and location either way.

Can I make a copy without opening the workbook?
Yes. In Windows File Explorer or Mac Finder, copy and paste the file, then rename the duplicate. This duplicates the file as it currently exists on disk; it will not include unsaved changes in an Excel window.

Will formulas and formatting be copied?
Yes, when you save a workbook as another Excel workbook, its sheets, formulas, and formatting are normally retained. Features that depend on links, external data, permissions, or a different file format may behave differently, so check important content in the copy.

Can I save a copy to a flash drive or another computer?
Yes, if the destination is available and you have permission to write to it. For a flash drive, select it in the Save As dialog and wait for the save to finish before removing it. To move a copy to another computer, save it to a shared cloud location or transfer the file using an approved method.

How do I keep editing the original after making a copy?
Check Excel’s title bar after saving. If it shows the copy’s name, use File > Open to reopen the original from its original location. Make sure the original is active before making further changes.

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.