Microsoft Excel For Mac Not Saving Files

Posted on by admin
  1. Excel Not Saving Changes
  2. Excel For Mac Can't Save File
  1. Some of the content in this topic may not be applicable to some languages. The file formats that are listed in the Save As dialog box vary, depending on what type of sheet is active. If you are saving your file into a different format, in most cases, Excel converts only the active sheet.
  2. Stellar File Repair works for Microsoft Excel 2000, 2003, 2007, 2010, 2013, and 2016. Use the following simple steps to repair you are corrupted or damaged Excel and also, recover your data. If you are satisfied with the result, select the 'Save File' option from the main menu to save the file.

To save a file to an online location other than the default folder, use Save as. You can save files from Word, Excel, or PowerPoint directly to folders on OneDrive and SharePoint services. On the File menu, click Save as, or press + Shift + S. If the dialog box shows a folder on your computer rather than on an online service, click Online. Excel saving errors mainly occur when the procedure, that Microsoft Excel uses to save a file, malfunctions. For instance, if you are saving a file to your external drive, your connection experiences problems; or say, the USB you are locating your file at is removed from your system.

'How to restore previous version of Excel file Mac after I overwrote some data and saved it? I’ve searched several threads but one of them got what I need exactly.'

Many people asked the same question in different forums over the internet. It’s a dilemma that you’re afraid of losing the latest version of Excel, so you press Command and S regularly to save it. However, the latest version is not always the one you want especially your Mac automatically changed the data on the Excel without your permission. Here in the following, I’m going to tell you how to recover previous version of Excel file on Mac in Microsoft Excel for Mac 2011, 2016 and 2020.

Quick Navigation
Method #1. Press Command and Z to Recover Old Version of Excel File on Mac
Method #2. Recover Saved Over Excel File on Mac with the Built-in Tool
Method #3. Scan for the Lost/Deleted Excel File on Mac with Software

Method #1. Press Command and Z to Recover Old Version of Excel File on Mac

If you’re working on the Excel file or have kept the Excel opening all the time, you can try to press the Command and Z button at the same time to recover old version of excel file on Mac. It is the easiest way. However, you have to do the get-back several times.

Method #2. Recover Saved Over Excel File on Mac with the Built-in Tool

Many software tools on Mac are able to save versions of documents automatically whenever you open, duplicate, close or even delete the documents. It is the same with Worksheet on Mac. In this case, you can easily recover any of the previous version of the Excel file you need. Here are the steps for how to recover previous version of excel file on Mac:

1. Open the latest version of the Excel file. And then choose 'File' > 'Restore' > 'Restore to Last Saved to Recovering'. Next, you need to tick marks along the timeline to browse all versions of the Excel file. It could be a long list if you have edited the Excel file many times.

2. Find the previous version of the Excel file you need and choose how you want it to be on your Mac. If you want to restore the current version to the previous version, click 'Restore'. If you just want to save it to your Mac without overwriting the current one, press and hold the Option key, then click 'Restore a Copy'.

My suggestion for you is to save a version explicitly. All you need is to open the previous excel file on Mac, then choose 'File' > 'Save' > 'Save As'. After then, you can choose a place on your Mac to recover previous version of Excel file on Mac with a different name.

Method #3. Scan for the Lost/Deleted Excel File on Mac with Software

If you only need to recover the previous version of the Excel file on Mac, I think method 2 will do. However, if the Excel file is lost or deleted, you can recover it only with the help of a professional Mac excel file recovery tool, like iBeesoft Data Recovery for Mac. In the following, how to restore permanently deleted or lost Excel files on Mac with Software.

Step 1. Install iBeesoft Data Recovery on Mac

Download iBeesoft Data Recovery for Mac on your computer. It is virus-free, professional and trustworthy data recovery software which is designed for people to recover Excel file on Mac. It is fully compatible with Excel and macOS Mojave and former versions.

Step 2. Select Files to Scan

Launch the Mac excel file recovery software is ready to scan for all the supported files by default. You need to uncheck the unwanted file types, only keeping the 'Documents ' option selected and click 'Start' to recover deleted or lost previous version of Excel file on Mac.

Step 3. Select Mac Drive to Scan

All hard drive of your Mac are listed in the main window. From there, you need to select the one from where you have lost the Excel file. And then, click 'Scan'.You can see the software is scanning your Mac for the Excel worksheets right away.

Step 4. Excel Mac Recover Previous/Lost Version

It only take a few seconds for the data recovery software to scan your Mac for the Excel files. After then, you can see all the found worksheet files are listed in the result window. Find the one you need and click 'Recover' to save them to your Mac again.

Related Articles

Applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007

Repairing your Office programs can resolve issues with Excel not responding, hanging, or freezing by automatically repairing errors in Office files. For detailed instructions on doing Excel not responding fix by repairing Microsoft Office, navigate to the corresponding part. If repairing your Office programs doesn't resolve the issue, continue on to try other solutions in this tutorial.

How to fix Excel not responding when saving? Try out with the quick ways below.

Workable SolutionsStep-by-step Troubleshooting
Fix 1. Install the latest MS OfficeOpen Word or Excel. Go to 'File' > 'Account'.Under Product Information, choose 'Update Options'...Full steps
Fix 2. Open Excel in Safe modeType excel.exe /safe in the Run box to open the Excel in safe mode. Check if the software still crashes...Full steps
Fix 3. Make sure Excel is not usedIf you try to perform other actions when Excel is in use, it may not respond. End the task in the process...Full steps
Fix 4. Disable Add-insOpening Excel in safe mode, click 'File' > 'Options' > 'Add-ins'. Select 'COM Add-ins', and click 'Go'...Full steps
Fix 5. More effective fixesYou can also fix the issue by checking antivirus/conflicts, repairing, uninstalling, reinstalling Office...Full steps

Microsoft Excel is the most used form tool by individuals or enterprises for calculation of profit/loss to finding averages, charting, and graphing data. Important programs like Excel need to run smoothly to keep the data safe. However, the truth is that many users often experience errors when opening or saving Excel. You may receive one of the following error messages:

  • 'Microsoft Excel is not responding'
  • 'Microsoft Excel has stopped working'
  • 'A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.'

As you can see in the above screenshot, Microsoft offers you three solutions - restart the program, close the program, or wait for the program to respond. Most users, especially those who didn't save their document will not try these methods to fix the Excel is not responding issue because they might run the risk of losing data. Then, what to do when Excel is not responding, and how to save Excel file in this case?

This article covers the most common methods to settle Excel not responding error, which may be caused by one or more of the reasons listed below. You can follow the solutions in order or selectively.

Why Is Excel Not Responding

Reasons for Excel not responding, hanging, or freezing may be as follows.

  • Microsoft Office is not the latest update.
  • Excel may be in use by another process.
  • Conflict with a program, process, service, or installed add-ins in Excel.
  • Problems result from Excel file contents.
  • Antivirus software is outdated or conflicting with Excel.

9 Effective Ways to Fix Excel Not Responding

We try to provide comprehensive solutions for Excel not responding fix. If you had tried one or a few of them before but failed, then choose those you haven't tried yet. These methods work with different Excel versions, including Excel 2010, 2013, 2016, even 2019.

1. Install the Latest Microsoft Office

If you haven't upgraded to the latest Office and Windows Updates, the problem may occur. So, check and install the most recent versions. We highly recommend you turn on the option of automatically installing any updates for Windows. You can do this by going to the 'Control Panel' > click 'System and Maintenance' > select 'Maintenance' to expand its options > turn on 'Automatic Maintenance'.

How to install Office updates to fix Excel not responding when saving:

  • Open any Office app, Word, or Excel. Go to 'File' > 'Account'.
  • Under Product Information, choose 'Update Options' > 'Update Now'. You can also choose 'Disable Updates', and 'View Updates' here.

2. Open and Save Excel in Safe Mode

To solve Microsoft Excel not responding problem, you can open Excel in safe mode. When you run Excel in safe mode, it bypasses functionality and settings such as alternative startup location, changed toolbars, and Excel add-ins. Now, try open and save Excel in safe mode when it is not responding.

You can open Excel in safe mode by pressing and holding Ctrl while you start the program, or by using the /safe switch (excel.exe /safe) in Command Prompt.

3. Make Sure Excel Is Not in Use by Another Process

If Excel is in use by another process, this information will be displayed in the status bar at the bottom of the Excel window. If you try to perform other actions while Excel is in use, you may encounter Excel not responding issue. Therefore, end the task in the process before any other operation. If Excel is not used by another process, but it is still not responding or hanging, try the next method.

4. Disable Add-ins

Excel Not Saving Changes

Add-ins may occasionally interfere or conflict with Excel. You can try to fix Excel is not responding or frozen issue by disabling add-ins.

Error
  • Enter safe mode by pressing and holding Ctrl while you start the program, or by using the /safe switch (excel.exe /safe) in Command Prompt.
  • Click 'File' > 'Options' > 'Add-ins'. Select 'COM Add-ins', and click 'Go'.
  • Uncheck all the add-ins in the list, and click 'OK'. Then restart Excel.

If the Excel works normally, re-enable the add-ins one-by-one until Excel not working happens again. Thus, you may figure out which add-in is causing the problem.

5. Investigate Excel File Details and Contents

Sometimes, the details and contents in Excel may cause Excel not responding when saving. The following things can cause performance or Excel crashing issues:

  • Formulas referencing entire columns.
  • Array formulas referencing an uneven number of elements in the arguments.
  • Hundreds, or perhaps thousands of hidden or 0 height and width objects.
  • Excessive styles caused by frequent copying and pasting between workbook.
  • Excessive, and invalid defined names.

You can remove the problematic contents and see if Excel not responding still occurs. If the issue is not resolved yet, go to the next method.

6. Check for the Program Conflict by Performing Clean Boot

When you start Windows, several applications and services start automatically and run in the background. These applications and services may interfere and conflict with your Excel and lead to Excel not responding when saving. You can perform a clean boot that can help you identify problems with conflicting applications.

To perform a clean boot on your computer, log on as the administrator, then follow these steps:

Step 1. Type msconfig in start search and hit Enter to open the System Configuration Utility.

Step 2. Click the 'General' tab, and then click 'Selective startup'. Check 'Load System Services' and 'Use Original boot configuration' options.

Step 3. Click the Services tab. Select the 'Hide All Microsoft Services' check box. Now click 'Disable all'.

Step 4. Click 'Apply/OK' and restart the computer. This will put Windows into a Clean Boot State. Then, check if the Excel is still frozen and not responding. If your issue is not resolved, continue on to the next item.

7. Update or Close Anti-virus Software

Excel not responding may be the conflict between Excel and the anti-virus software. So you can try to disable your anti-virus and see if the error has been resolved. Also, you can upgrade the anti-virus software to address the issue.

Note: Turning off your antivirus software may make your PC vulnerable to viral. Try this way carefully.

8. Repair Microsoft Office

Another useful fix for Excel is not responding is repairing Microsoft Office.

  • Go to the 'Control panel' > choose 'Programs and Features'. Find Microsoft Office in the list, right-click it and click the 'Change' button.
  • Then the repair window will pop-up. Choose 'Quick Repair' and click the 'Repair' button. When the process completes, check if the problem has been solved. If this does not work, retry the steps, but choose 'Online Repair' instead. If the problem still exists, uninstall and reinstall Office.

9. Uninstall and Reinstall Office

If none of the previous methods work, you may have to reinstall Microsoft Office. You can download it on Microsoft's official website.

How to Save Excel File When Excel Not Responding

Some users want to fix Excel not responding without closing, which may be impossible. But don't worry, although you have to close the frozen Excel and face unsaved data loss. You can use the following useful methods to save and recover Excel files when Excel not responding.

1. Recover Excel from Document Recovery

If you have saved the Excel file earlier, but the latest changes you did are not saved because Excel crashed or Excel not responding, you can recover the unsaved edition with the Document Recovery feature.

Step 1. Open the Excel application, find 'Recovered', and click 'Show Recovered Files'.

Step 2. The 'Document Recovery' pane will display the unsaved files. Open and save the one you need.

2. Save Excel from Temporary File

Temporary files work as backups. If you lost the unsaved Excel file because of Excel not responding when saving, you can find the temporary file and recover it.

You can go to the following path to find the unsaved Excel file:

C:Users[username]AppDataLocalMicrosoftOfficeUnsavedFiles

Or you can make it with the guides below.

Step 1. Open Excel, and click 'File' > 'Info' > 'Manage Workbook'. Click 'Recover Unsaved Workbooks' from the drop-down menu.

Step 2. Select the unsaved file and click the 'Open' button. Then, on the pop-up window, choose 'Save As' to recover it.

If you also need the guide on how to recover unsaved Excel file on Mac, here is the quick access.

See More: How to Recover Deleted/Lost Excel Files

Unlike the unsaved files that you can recover with the AutoRecovery feature, if you accidentally deleted or lost an Excel document on your computer, you need to turn to professional file recovery software for help. EaseUS Data Recovery Wizard can restore lost Excel files from HDD/SSD, external hard drive, USB flash drive, pen drive, SD/CF card, and more. It specializes in emptied recycle bin recovery, formatted recovery, lost partition recovery, virus attack recovery, etc.

Now, download and install this capable data recovery tool on your computer; both PC and Mac are supported. Then steps below to recover deleted and lost Excel files.

Step 1. Select a location and start scanning

Launch EaseUS Data Recovery Wizard, hover on the location where you lost data, then click 'Scan'.

Step 2. Preview and select the files

Wait until the scanning completes. You can use Filter or search bar to find lost files.

Step 3. Recover lost data

Then choose a location to save the recovered data, and click 'OK'. You should store the data in another place instead of the original one.

The End

This article provides you with a lot of information on Excel not responding issue. There are nine feasible solutions in all. You can try all these and see which one works for you. If you don't know how to save Excel files when Excel not responding, use the Document Recovery feature or temporary files to recover unsaved Excel files.

Besides, EaseUS Data Recovery Wizard is available for you to recover deleted or lost Excel, as well as Word, PPT, PDF, etc. without any effort. Give it a try, and you won't be disappointed.

Frequently Asked Questions About Excel Not Responding

The following are the top topics related to Excel not responding issue. Check the brief answers to these problems.

What to do when Excel is not responding?

When Excel not responding, hangs, freezes, or stops working, try these ways:

  • Start Excel in safe mode.
  • Install the latest updates.
  • Check to make sure Excel is not in use by another process.
  • Investigate possible issues with add-ins.
  • Investigate Excel file details and contents.
  • Check whether your file is being generated by a third party.
  • Check for a program, process, or service conflicts with Excel.
  • Repair your Office programs.
  • Check to see if your antivirus software is up-to-date or conflicting with Excel.

How do you unfreeze Excel?

When your Excel keeps freezing, crashing, or not responding, there are some methods you can try to troubleshoot.

  • Disable COM Add-ins
  • Repair Office installation
  • Repair corrupted template
  • Run Excel in Safe Mode
  • Reinstall MS Office

If you want to unfreeze panes, open your Excel spreadsheet. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Then click on the Unfreeze Panes option in the popup menu.

Why do I keep getting excel not responding?

Excel not responding, keeps hanging or freezing may occur for one or more of the following reasons:

  • You have not installed the latest updates.
  • Excel may be in use by another process.
  • A previously installed add-in may be conflicting with Excel.
  • You need to repair Office programs.
  • Antivirus software may be outdated or conflicting with Excel.

How long until Excel is not responding?

Excel For Mac Can't Save File

8-10 seconds

Excel may enter 'Not Responding' (freezing) mode for a few seconds too, usually 8-10 seconds. It may be faster or slower on different computers. You need to wait patiently in this case. If you encounter Excel not responding when saving finally, solve the problem using the solutions in this post.