why can't I edit and save an excel spreadsheet

Forbes 0 Reputation points
2026-11-07T13:11:56.0333333+00:00

I have opened an excel spreadsheet I want to edit and save. The save icon is greyed out so I can't save.

I am using a MacBook Neo

Microsoft 365 and Office | Excel | Other | MacOS
0 comments

3 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-11-07T13:12:12.2833333+00:00

    Common causes are:

    1. The workbook is opened from a shared location and another person already has it open in the desktop version of Office. In that case, the file can be viewed but not edited until the other person closes it. If changes are needed immediately, use File > Save As to create a copy and edit that copy.
    2. The file is effectively read-only because edit permissions are missing. Excel needs Read, Write, Modify, and Delete permission on the folder where the file is being saved. If those permissions are missing, save can fail or stay unavailable.
    3. Excel on the Mac may not be properly activated or signed in. In Mac scenarios where Save and Save As are greyed out, accepted resolutions include:
      • In Excel, use Excel > Sign Out.
      • Restart the Mac.
      • Open Excel again and sign in with the account that owns the Microsoft 365 subscription or Office license.
      • Then test File > Save and File > Save As.
    4. If the file is locked for co-authoring, unsupported workbook features can cause the lock. On Mac, possible fixes include:
      • Remove workbook protection if enabled from the Review tab.
      • Remove restricted access from File > Restrict Permissions > No Restrictions.
      • Turn off Refresh data when opening file on tables or PivotTables.
      • Disable Excel add-ins from Tools > Excel Add-ins.
    5. A third-party add-in can interfere with saving. Test Excel in Safe mode:
      • Exit Excel.
      • Start Excel while holding Ctrl.
      • When prompted to start in safe mode, select Yes.
      • Open a workbook and test saving. If saving works in Safe mode, an add-in or startup file is likely the cause.
    6. Other save blockers include:
      • Not enough free disk space
      • Antivirus software interrupting the save process
      • Saving to an external or network drive with a failed connection
      • A file path longer than 218 characters

    A practical order to try on the Mac:

    1. Check whether the file is opened from a shared location and locked by another user. If so, use File > Save As to make a copy.
    2. Sign out of Excel, restart the Mac, and sign back in.
    3. Save the workbook to a different local folder on the Mac to rule out permissions, network drive, or external drive issues.
    4. Disable Excel add-ins and test again.
    5. If the workbook is shared or co-authored, remove unsupported features listed above.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. DaveM121 946.3K Reputation points Independent Advisor
    2026-11-07T13:44:37.51+00:00

    1

    Is this problem affecting one workbook or all Excel workbooks?

    2

    What version of Microsoft Office do you have, is that a subscription to Microsoft 365 or a standalone version of Office like Office 2019, 2021 or 2024.

    3

    At the top left of your Mac desktop, click the Apple icon and select 'About this Mac', what version of MacOS is installed on your computer?

    Was this answer helpful?

    0 comments
  3. Marcin Policht 112.5K Reputation points MVP Volunteer Moderator
    2026-11-07T13:45:53.32+00:00

    This might be caused by an expired or unverified Microsoft 365 license or subscription, an outdated Office or macOS version, or corrupted preference and container files.

    The most common issue is your Microsoft 365 license state. If your subscription expired or you were signed out, Excel enters a reduced functionality mode. This mode lets you open and view files but blocks editing and saving. You can fix this by going to the top menu in Excel, clicking Activate or Sign In, and logging back into your active Microsoft account.

    Software updates can also resolve the glitch. You should update your system by going to the Apple menu, choosing System Settings, selecting General, and running Software Update. Afterward, open the Mac App Store and check the Updates tab to ensure Microsoft Excel is running its latest version.

    If the software is up to date, corrupted configuration files might be blocking the save function. You can clear these by quitting all Office apps and opening Finder. Press Command, Shift, and G together, then go to the Preferences folder in your user Library. Find the file named com.microsoft.Excel.plist and move it to your Desktop. If that does not work, use the same Finder shortcut to navigate to the Containers folder in your user Library, locate the folder named com.microsoft.Excel, and move it to your Desktop before restarting the app.

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.