To save a separate copy of an Excel workbook in Microsoft 365 for Windows, open the workbook and choose File > Save a Copy if that option appears, then choose a folder, enter a different file name, and select Save. If you do not see Save a Copy, use File > Save As > Browse and save the workbook under a new name. This gives you a second file while preserving the original.
What You’ll Need
- The workbook you want to duplicate, open in the Excel desktop app or available in Excel for the web.
- A destination folder where you can create files, such as a local Documents folder, a shared network folder, or a OneDrive folder.
- A distinct file name for the copy. If you need to keep features such as macros, be ready to choose a file type that supports them.
Before you start, check whether your latest changes have finished saving, particularly if the workbook is stored in OneDrive or SharePoint. In desktop Excel, look near the top of the window for a saving or saved status. In Excel for the web, changes are generally saved automatically, but wait for any saving indicator to finish. A copy made before pending edits are saved may not include those edits.
Step-by-Step
- Open the workbook you want to copy. Confirm that it is the correct file by checking the workbook name and, if needed, a few key sheets or cells. If Excel opened it in Protected View, select Enable Editing only if you trust the file and intend to make changes. You can make a copy without changing the workbook’s contents, but starting from the right source prevents confusion later.
- Open the File menu. Select File in the upper-left corner of the Excel window. This opens the Backstage view, where saving and file-management commands appear. Do not use the ordinary Save command if your goal is to preserve the existing file and create another one: Save writes changes to the current workbook.
- Choose the copy or save-as command available for your file. If you see Save a Copy, select it. This is common when working with a workbook saved in OneDrive or SharePoint. If Save a Copy is not shown, select Save As, then choose Browse to open the Windows Save As dialog. For a file stored on your computer, Save As is a standard way to create a separately named copy.
- Select where the copy will be stored. In the Save As dialog, browse to the intended folder. You can use the same folder as the original if you want the two files together, or choose another location to keep the copy separate. For a cloud workbook, choose an available OneDrive or SharePoint location if you want the new file stored online. Check the folder path before continuing; a correct name saved in an unexpected folder can be hard to find.
- Enter a new file name. Use a name that distinguishes the copy from the source, such as
Quarterly Sales - Review Copy.xlsxorProject Plan - 2026-11-03.xlsx. In the Windows dialog, enter the name in the File name box. Excel may add or display the file extension based on the selected file type. Avoid giving the copy exactly the same name in the same folder, because Windows may ask whether you want to replace the existing file. - Check the file type before saving. For a standard workbook without macros, Excel Workbook (*.xlsx) is usually appropriate. If the source contains VBA macros, choose Excel Macro-Enabled Workbook (*.xlsm) to retain them. Some older or specialized formats have different feature limits. If Excel warns that a feature is not supported in the selected format, stop and choose a format that preserves the feature you need rather than accepting a conversion unintentionally.
- Select Save, then confirm the result. Click Save. If Excel asks whether to replace a file, read the prompt carefully. Choose the option to replace only if you intentionally want to overwrite that particular destination file; otherwise cancel and use a different name or folder. After saving, check the title bar or File information to see which file is open. With Save As, Excel normally switches to the newly named copy, so later edits may go into that copy rather than the original.
- Verify both files are present. Use File > Open or File Explorer to check that the original and the new copy exist in the expected locations. If you need to keep the original unchanged, do not make further edits to the copy thinking they will also update the source. The two workbooks are separate files; changes made in one do not automatically appear in the other.
Excel for the web: Open the workbook, select File > Save As > Download a Copy when that option is available. The browser downloads a separate file to its normal download location, and you can move or rename it there. To create another cloud-stored workbook, use the available Save a Copy command or make a copy from OneDrive or SharePoint, depending on the file and your organization’s permissions. The exact choices can differ between personal and work accounts.
Excel for Mac: The labels and dialog layout can vary by release. Use File > Save As, enter a new name, and choose a location; if your version shows Save a Copy, that is also suitable. The Mac keyboard shortcut for Save As is usually Command+Shift+S. On Windows, F12 opens the Save As dialog in desktop Excel. Keyboard behavior can depend on your Mac keyboard settings, so the File menu is the dependable route.
Common Mistakes
- Using Save instead of Save As or Save a Copy. Save updates the workbook currently open. It does not make a second file. If you need a separate version, start with Save a Copy or Save As and give the destination a distinct name.
- Overwriting the source by reusing its name and folder. Excel or Windows may warn that a file already exists. Do not confirm replacement unless that is intentional. Cancel, adjust the name, or select another folder.
- Assuming the original remains active after Save As. Save As commonly saves the new file and then switches the open workbook to that copy. Check the displayed file name before editing. Save a Copy may behave differently by storage location and Excel interface.
- Changing a macro-enabled workbook to .xlsx. The .xlsx format does not store VBA macros. Choose .xlsm if you need to retain VBA, and review any format warning before proceeding. The same caution applies to features that a chosen older or alternate format cannot preserve.
- Saving to a cloud folder without checking sync or access. A copy in OneDrive or SharePoint can take time to upload, and a work account may restrict where files can be created. Confirm that the save completed and that you have permission to access the destination.
- Expecting a copy to stay synchronized with the original. A saved copy is a separate workbook, not a live duplicate. If you need current information from both, you must update the files separately or use a deliberate collaboration or linking workflow.
Tips
- Use a naming pattern. Include a purpose, date, or version label, for example
Inventory - Before Import.xlsxandInventory - After Import.xlsx. Consistent names make it easier to identify the source and compare versions later. Use dates in a format that sorts clearly, such as year-month-day. - Keep a clean original. If the point is to experiment, save the duplicate first and confirm which file is open before trying changes. For especially important workbooks, keep the untouched original in a separate, access-controlled folder rather than relying on a filename alone.
- Choose the right destination for the job. A local folder can be useful for a temporary working copy. OneDrive or SharePoint can make a copy available across devices or to collaborators, but sharing permissions still apply. Avoid storing sensitive workbook data in a location that is not approved for it.
- Retain the correct format. Most everyday workbooks use .xlsx. Keep .xlsm for workbooks that must retain macros. If you rely on external connections, specialized data features, or compatibility with an older Excel release, check the format warning and test the copy before treating it as a full replacement.
- Make the copy before a risky edit. A dated or clearly labeled copy provides a practical checkpoint before a large cleanup, import, or layout change. It is not a substitute for an organization’s backup policy, but it can help you return to the earlier state without overwriting the source.
Troubleshooting
You cannot find Save a Copy. Use File > Save As instead. In desktop Excel for Windows, select Browse if you need to pick a folder in File Explorer. If the workbook is in a browser, check File > Save As for Download a Copy, or use the storage service’s copy command if you need another cloud file.
Excel says the file is read-only or you do not have permission. You may be able to save a copy to a folder where you have write access, even if you cannot overwrite the source. Choose a permitted destination and a new name. If the file is protected by an organization, password, or rights policy, contact the owner or administrator rather than trying to bypass the restriction.
The copy is missing your latest edits. Return to the original and confirm that the edits are visible and saved. In a cloud workbook, wait for the saving status to complete, then make the copy again. If you have already saved the copy, you can repeat the process with a new name, or update the copy carefully after confirming which file is open.
The copy is not where you expected. Check the folder selected in the Save As dialog and the browser’s Downloads folder if you used Excel for the web. In Windows, open File Explorer and search for the distinct part of the file name. For OneDrive or SharePoint, confirm the account and folder; copies saved under another account or library may not appear in the location you first checked.
The copy loses a feature or Excel displays a format warning. Cancel the save if you are unsure, then reopen the Save As dialog and choose a compatible format. Use .xlsm when macros must remain. If a warning concerns a feature you depend on, keep the source intact and test the copy before relying on it. Ask the workbook owner or IT support if you cannot determine which format is required.
Frequently Asked Questions
Does Save As change or delete the original workbook?
Normally, no. Saving under a new name creates another file and leaves the original in its existing location. However, Excel usually switches to the new copy after Save As, so check the workbook name before making later edits.
What is the difference between Save a Copy and Save As?
Both can produce a separate file, but the available command and what Excel keeps open can depend on the file’s location and the version of the interface. Save a Copy is often offered for cloud files and is intended to create another file while retaining the source as the current workbook. Save As saves under a new name and commonly opens that newly saved file.
Can I save the copy in the same folder as the original?
Yes. Give it a different file name so it does not collide with the existing workbook. A clear suffix such as “Copy,” “Review,” or a date helps distinguish the two files.
Will the copy include formulas, charts, and formatting?
Usually, yes: saving a workbook as another Excel workbook preserves its sheets and workbook content. Some features may not be supported by a different file format, and external links may still point to their original sources. Review Excel’s format warnings and check important parts of the saved copy.
How do I make a copy without downloading it?
In desktop Excel, save the copy to a local or cloud folder. For a workbook stored in OneDrive or SharePoint, use the available Save a Copy command or the storage service’s copy option to create another cloud file. In Excel for the web, Download a Copy creates a local download rather than another cloud-stored workbook.
Can I undo saving over the wrong file?
Saving over a file is not reliably reversible with Ctrl+Z. If you replaced the wrong destination file, check OneDrive or SharePoint version history, the Windows Recycle Bin, or your organization’s backup system. Recovery options depend on where the file was stored and your account permissions, so act promptly and avoid making further changes to the affected file.
Related
- Protect an Excel Workbook From Opening with a Password
- How to Print an Excel Sheet on One Page Without Clipping
- Print in Excel Without Cutting Off: Page Setup Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets IFS: How It Works and When to Use ItIn Google Sheets, IFS checks conditions in the order you list them and returns the result paired with…
- How to Change Border Thickness in Excel for Clearer SheetsTo change border thickness in Excel for Microsoft 365 on Windows, select the cells, open Home > Borders…
- Share a Google Calendar in Outlook: Step-by-StepTo see a Google Calendar in Outlook, copy its iCal address from Google Calendar and add it to…
- Find and Replace in Excel: Steps, Options, and TipsTo find and replace text in Microsoft Excel for Microsoft 365 on Windows, press Ctrl+H, enter the text…
- Excel Mac Conditional Formatting: Rules and FixesIn Excel for Mac, select the cells you want to format, then choose Home > Conditional Formatting and…
- Excel Workbook History: View, Compare, and Restore VersionsTo view Excel workbook history, open a workbook saved in OneDrive or SharePoint and choose File > Info…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.