If you cannot use Save As in Excel, open File > Save As and choose Browse to save a copy in a folder you can access. If the command is unavailable or saving fails, check whether the workbook is read-only or protected, whether the destination is available, and whether the file name and format are valid; the exact cause depends on the message Excel displays.
What Save As does in Excel
Save updates the workbook at its current location, while Save As creates a copy with a chosen name, location, or file format. It is useful when you need to preserve an original, move a workbook, or make a version for someone using different software. In Microsoft 365 for Windows, choose File > Save As > Browse to open the Windows save dialog. Pressing F12 in desktop Excel also opens Save As; on some laptops, you may need to press Fn+F12.
Save As is not the same as changing a worksheet’s protection settings. A protected sheet may stop you editing particular cells, but sheet protection by itself does not normally prevent saving a separate copy of the workbook. Likewise, a read-only workbook often can be saved under a new name even though the original cannot be overwritten. If Excel refuses the copy too, look for a separate permissions, location, or application issue.
Try a reliable Save As sequence
First, use a simple local destination to determine whether the problem is the workbook or its usual storage location. In Excel for Microsoft 365 on Windows:
- Select File > Save As > Browse. If the workbook has not been saved before, Excel may show a Save As window immediately.
- In the save dialog, select a folder you can access, such as Documents. Avoid a shared network folder for this test.
- Enter a short, distinctive file name, such as
Project-copy.xlsx, and keep the file type as Excel Workbook unless you have a reason to change it. - Select Save. If Excel displays a format or compatibility warning, read it before choosing whether to keep the selected format.
If this works, the original folder, file name, or file format is a more likely source of the trouble than the workbook itself. You can then try the intended location again or check its permissions. If saving to Documents fails too, note the full error message and continue with the checks below. Avoid repeatedly clicking Save if Excel reports that it cannot write the file; first confirm whether a copy was created in the destination folder.
When Save As is greyed out or missing
A disabled command usually points to the state of the application, workbook, or account, rather than a bad file name. Check the window for a banner or prompt. A workbook opened in Protected View may be restricted until you choose Enable Editing. Only do this for a file you trust: Protected View is a security precaution for files from locations such as the internet or email attachments. If editing is not enabled, save a copy only if Excel offers that option and you are confident the file is safe.
Look for signs that the workbook is open in a restricted or shared state. Another person may be editing a file on a shared drive, or your account may have view-only access to a SharePoint or OneDrive file. In those cases, ask the owner for editing permission or use an available copy option to create a separate workbook in a location you control. A workbook marked read-only does not always disable Save As; it may simply prevent changes to the original.
- If Excel shows an activation or sign-in warning, resolve the account or licensing prompt and reopen the workbook if needed.
- If a file came from an email or download, check whether the Protected View banner is present before trying to edit it.
- If only certain cells cannot be changed, worksheet protection is more likely than a Save As problem. Ask for the sheet password or an editable copy if appropriate.
Check the destination and access permissions
Excel can prepare a workbook correctly and still fail when Windows cannot write to the selected folder. A shared drive may be disconnected, a network connection may have dropped, or your user account may have permission to open a file but not create new ones there. Try saving to a local folder such as Documents. If that succeeds, ask the folder owner or your IT administrator to check your write access, or select a destination where you are authorized to save.
Also check that the drive has free space and that the destination folder still exists. External drives can disconnect, and removable media may be write-protected. If the folder is synchronized through OneDrive, SharePoint, or another service, a pause in syncing or an account sign-in problem can interfere with saving. Save a local copy first when possible, then address the sync status before uploading or replacing the shared version.
Excel may report that another user has the file open or that it cannot access a particular file. Close other Excel windows that may have the same workbook open, and ask collaborators to finish editing if the file is shared. Do not delete temporary or lock files from a shared folder unless you understand the situation and have permission; another person may still be working in the workbook.
Use a valid file name and format
Windows does not allow certain characters in file names: < > : " / \ | ? *. A name also cannot end with a period or a space. Replace punctuation that Windows rejects with a hyphen or underscore, and shorten an unusually long name or folder path. For example, change a name containing a slash to Quarterly-results.xlsx. If the error appears only for one particular name, try a short name using ordinary letters and numbers.
Choose a format that matches what the workbook contains. .xlsx is the standard Excel workbook format and does not store VBA macros. Use .xlsm if you need to retain VBA macros. Saving as .csv is suitable for plain, tabular data, but it does not preserve the full workbook: formatting, formulas as workbook formulas, charts, multiple sheets, and other Excel features may be lost or changed. Excel normally warns when a selected format cannot keep all workbook features. Do not dismiss that warning without checking whether you need those features.
Changing the extension by typing a different ending into the file name is not a reliable way to convert a workbook. Select the intended type from the file-format menu in the Save As dialog. If a particular format is unavailable, your Excel version, organizational policy, or the file’s contents may limit the choices.
Cloud files, shared workbooks, and copies
For files stored in OneDrive or SharePoint, saving can depend on both Excel and the account’s access to the cloud location. Check whether Excel is signed in to the account that owns or can edit the file, and look for sync, upload, or connection warnings. If the original is view-only, or you want to keep it unchanged, use Save As to create a new file in a location where you have permission rather than trying to replace the shared original.
Excel may display cloud-oriented choices instead of the familiar Windows file dialog. These options can include saving a copy or downloading a copy, and the wording can vary by account and interface. A downloaded copy is stored on the computer; it is not automatically the same as an updated cloud file. If you edit that local copy later, you will need to upload it or save it to the cloud separately to share those changes.
If autosave is enabled for a cloud workbook, it continually saves changes to that workbook’s current location. That does not remove the purpose of Save As: use a copy when you need a different file or want to leave the existing workbook untouched. Before sharing a replacement, confirm the folder and name so you do not accidentally create multiple confusing versions.
Recover work if saving keeps failing
If Excel is still open, do not close it just because Save As failed. Try saving a copy to a local folder with a short name and the standard .xlsx format, unless the workbook needs macros—in that case, choose .xlsm. If the error mentions a full disk, unavailable location, or permission problem, fix that specific issue or choose a different approved destination. Keep the workbook open until you confirm that the saved copy exists and opens.
If Excel closes unexpectedly, reopen it and check the Document Recovery pane or the recovery options Excel offers. AutoRecover and recovery behavior depend on the app’s settings and the circumstances of the closure, so they are not a substitute for saving. For a workbook that matters, make a copy once it is safely saved and use a clear version name. Do not assume an unsaved recovery copy contains every recent change.
For a damaged or unusually complex workbook, try opening it in desktop Excel and saving a copy under a new name before making further changes. If Excel offers a repair option, follow the on-screen instructions and keep the original untouched. If the file contains confidential or business-critical information, contact your organization’s support team rather than uploading it to an unfamiliar repair website.
Differences on Mac and in Excel for the web
In Excel for Mac, use File > Save As and choose the name, location, and format in the Mac save dialog. The layout and available locations differ from Windows, but the key checks are similar: select a writable destination, use a valid name, and choose a format that preserves the workbook’s features. The Windows F12 shortcut should not be assumed to work the same way on a Mac; use the File menu or check the shortcut shown in your Mac version’s menus.
Excel for the web saves supported changes to the online workbook and does not use the Windows desktop Save As dialog. Open File > Save As to see the copy or download choices available in your account; labels can differ. If you need desktop-only features or a local file, open the workbook in the desktop app or download a copy. A downloaded workbook is separate from the online original unless you upload or save it back to the cloud.
Frequently Asked Questions
Why is Save As greyed out in Excel?
Check for Protected View, a view-only or shared workbook, an account warning, or an organizational restriction. If the workbook is safe and Excel offers Enable Editing, use it only when appropriate. Otherwise, request permission or try an allowed copy option.
Why does Excel say I do not have permission to save?
The selected folder or cloud file may not grant your account permission to create or replace files. Try a local folder you control. If that works, ask the folder or file owner for the required access rather than trying to bypass the restriction.
Can I use Save As if the Excel file is read-only?
Usually, read-only status prevents overwriting the original, not saving a separate copy. Choose a different name and a folder where you have write access. If Excel still blocks the copy, check for Protected View, account permissions, or another restriction.
How do I save an Excel workbook as a copy without changing the original?
Choose File > Save As > Browse in Excel for Windows, then select a different name or folder before saving. Confirm the destination afterward. For a cloud workbook, use the available Save a Copy option and check whether it creates a cloud copy or downloads a local file.
Will saving as CSV keep all my Excel sheets and formatting?
No. CSV is a plain-text data format and does not preserve a full multi-sheet Excel workbook, formatting, charts, or other workbook features. Keep an .xlsx or .xlsm copy if you need the complete workbook, and use CSV only when its data-only format suits the task.
Related
- Business Expense Tracking Excel Template: Setup & Use
- Bullet Point in Excel: Add Bullets to Cells and Lists
- Bullets in Excel: How to Add, Format, and Manage Lists
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Validation List: How to Add a Blank OptionYes. To add a selectable blank to an Excel data-validation drop-down, include a genuinely empty cell inside the…
- Excel Max Row Count: How Many Rows Can a Sheet Hold?Microsoft Excel for Microsoft 365 supports a maximum of 1,048,576 rows per worksheet, numbered 1 through 1,048,576. That…
- How to Get Text to Wrap in Excel Without Changing ColumnsTo get text to wrap in Excel, select the cell or cells, then choose Home > Wrap Text.…
- Superscript in Excel: Quick Key and Formatting StepsExcel has no single-key shortcut that directly applies superscript. In Excel for Microsoft 365 on Windows, select the…
- PowerShell Refresh Excel Power Query: How It WorksYes. On Windows, PowerShell can refresh Excel Power Query by automating the desktop Excel application through COM: open…
- How to Add a Running Header in Word 2010 Step by StepTo add a running header in Word 2010, open the document, choose Insert > Header, select a layout,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.