OneDrive File Issues

Fix Excel Shows Make a Copy Instead of Save As

Maira Mehtab Sep 22, 2026 869 views

Question details

Users want to know how to save a file when the 'Save As' option is missing and replaced by 'Save a Copy'.

Product: Excel for Microsoft 365
Device & OS: not provided
Scenario: Editing an Excel workbook that is stored in OneDrive or an online location with AutoSave enabled.
Observed behavior: The traditional 'Save As' option is removed from the File menu and replaced with 'Save a Copy', causing confusion about how to save file changes.

Before you start

Verify whether your Excel workbook is currently saved locally on your computer or hosted online in OneDrive by clicking the file name at the top center of the Excel window.

Solution 1Recommended

Understand AutoSave Behavior for OneDrive Files

When working with files stored in OneDrive, Excel hides 'Save As' by default because changes are saved automatically.

This is an intended behavior in Excel for Microsoft 365. When you open a workbook from OneDrive, AutoSave is automatically turned on. Because changes are continuously synced to the cloud, the traditional 'Save As' button is replaced to prevent accidental overwriting or sync conflicts.

Check AutoSave status

Look at the top-left corner of the Excel window to confirm that the AutoSave toggle is turned on.

Edit normally

Make your necessary changes to the workbook. You do not need to manually save, as changes are synced to OneDrive continuously.

Verify sync completion

Before closing the workbook, ensure the status text next to the file name at the top says 'Saved'. This guarantees all your data is securely stored online.

Automatic Saving: You can simply click the traditional Save icon (the floppy disk) to manually force a sync, but closing the document when it says 'Saved' is completely safe.

Solution 2

Use 'Save a Copy' to Create a New Version

If you need to duplicate the file or save it to a local folder like your Desktop, use the 'Save a Copy' feature.

Free Microsoft Office alternative

Try WPS Office for a Classic Save Experience

If you prefer the traditional 'Save As' feature without being forced into mandatory cloud sync behaviors, WPS Office offers a highly compatible, lightweight alternative to Microsoft Excel with an intuitive, familiar interface.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
2. Install the software: Run the installer and follow the on-screen instructions to complete the setup.
3. Open your files: Right-click your existing Excel workbooks and choose 'Open with WPS Spreadsheet' to enjoy a classic, hassle-free editing experience.

Retains the classic 'Save As' workflow for all local and cloud files100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Free to use with a lightweight installation and fast performanceFamiliar tabbed interface makes switching incredibly easy

microsoft office alternative - wps office

Frequently Asked Questions

Why is 'Save As' missing from my Excel File menu?

When you open a workbook stored in OneDrive or SharePoint with AutoSave enabled, Excel automatically replaces 'Save As' with 'Save a Copy'. This is a built-in feature designed to prevent users from accidentally overwriting their live online files.

Does 'Save a Copy' do the same thing as 'Save As'?

Yes. 'Save a Copy' functions exactly like 'Save As'. It allows you to create a duplicate of your current workbook in a new location or with a different name, leaving the original file completely unaffected.

How do I save my changes if 'Save As' is gone?

If AutoSave is turned on, you do not need to manually save your document; changes are synced to OneDrive continuously. Just wait until the status at the top of the Excel window displays 'Saved' before you close the application.

Can I force Excel to show 'Save As' again?

You can regain the 'Save As' option by turning off AutoSave using the toggle in the top-left corner, or by saving the file locally to your PC instead of opening it directly from OneDrive.

Document & File Issues