-->![For For](/uploads/1/2/5/6/125674882/287676134.jpg)
![Microsoft Microsoft](/uploads/1/2/5/6/125674882/401432128.jpg)
- Am Unable To Save Or Edit Microsoft Excel For Mac Tutorial
- Am Unable To Save Or Edit Microsoft Excel For Mac 2016
- Am Unable To Save Or Edit Microsoft Excel For Mac Update
- Am Unable To Save Or Edit Microsoft Excel For Mac For Dummies Youtube
- Am Unable To Save Or Edit Microsoft Excel For Mac Free
- Am Unable To Save Or Edit Microsoft Excel For Mac Pro
Jan 03, 2017 Unable to save edits to csv on Excel 2016 for Mac I am trying to edit a csv file that I downloaded successfully from Salesforce ( I experienced the same issue with a file I downloaded from another web app). Excel exits Edit mode and selects the cell directly below the current cell. You can also specify that pressing ENTER select a different adjacent cell. Click File Options Advanced.-OR-In Excel 2007 only: Click the Microsoft Office Button, click Excel Options, and then click the Advanced category.
Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
When you double-select an icon or file name for a Microsoft Excel workbook, Excel starts, then displays a blank screen where you expect the file content to appear.
Resolution
To resolve this problem, try the following methods, as appropriate, in the given order.
![For For](/uploads/1/2/5/6/125674882/287676134.jpg)
Method 1: Ignore DDE
This problem may occur if the Ignore other applications that use Dynamic Data Exchange (DDE) check box in Excel options is selected.
When you double-select an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel. This message instructs Excel to open the workbook that you double-selected.
If you select the 'Ignore' option, Excel ignores DDE messages that are sent to it by other programs. Therefore, the DDE message that is sent to Excel by Windows Explorer is ignored, and Excel does not open the workbook that you double-selected.
To correct this setting, follow these steps:
Note
This step can be skipped for Excel 2019 and Excel O365
- In the upper-left corner of the Excel window, select File, then Options.
- On the left side of the Options window, select Advanced to open the Advanced window.
- In the Advanced window, scroll down to the General section.
- Clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box, then select the OK button at the bottom of the window.
Note
For more information about how to turn off DDE, see 'An error occurred when sending commands to the program' in Excel
If these steps do not resolve the problem, continue to Method 2.
Method 2: Repair User Experience Virtualization (UE-V)
If you are running Update User Experience Virtualization (UE-V), install Hotfix 2927019. To do this, see the following Microsoft Knowledge Base article:
2927019 - Hotfix Package 1 for Microsoft User Experience Virtualization 2.0
If you are not sure whether you are running UE-V, examine the program list in the Programs and Features item in Control Panel. An entry for 'Company Settings Center' indicates that you are running UE-V.
If these steps do not resolve the problem, continue to Method 3.
Method 3: Reset file associations
To check whether the file associations in the system are performing correctly, reset the Excel file associations to their default settings. To do this, follow the steps for your operating system.
Windows 8.1/10
- Copy the file that is opening incorrectly, to your desktop.
- Right-click the file, and choose Properties
- On the General tab, next to Type of file, the type of file will be indicated within parenthesis. For example, (.docx), (.pdf), or (.csv).
The Opens with shows you which app it is currently associated with.
To open this type of file in a different app:
- Select Change.
- Select More apps.
- Select the desired app, then select the checkbox to Always use this app.
- Select the OK button.
Windows 8
- On the Start screen, type Control Panel.
- Select or tap Control Panel.
- Select Default Programs, then select Set your default programs.
- Select Excel, then select Choose default for this program.
- On the Set Program Associations screen, select Select All, then select Save.
Windows 7
- Select Start, then select Control Panel.
- Select Default Programs.
- Select Associate a file type or protocol with a specific program.
- Select Microsoft Excel Worksheet, then select change program.
- Under Recommended Programs, select Microsoft Excel.
- If Excel does not appear in this list, select Browse, locate the Excel installation folder, select Excel.exe, then select Excel.
If these steps do not resolve the problem, continue to Method 4.
Method 4: Repair Office
Try to repair your Office programs. To do this, follow the steps for your installation type and operating system.
For an Office 365 or Office 2019 Click-to-Run installation
Windows 10
- On the Start screen, type Settings.
- Select or tap Settings.
- In the Settings window, select or tap Apps.
- In the Apps & features window, scroll down to your Office program and select or tap it.
- Select or tap the Modify button.
- In the How would you like to repair your Office programs window, select or tap the Online Repair radio button, then select or tap the Repair button.
Windows 8
- On the Start screen, type Control Panel.
- Select or tap Control Panel.
- Under Programs, select or tap Uninstall a program.
- Select or tap Microsoft Office 365, then select or tap Change.
- Select or tap Online Repair, then select or tap Repair. You may have to restart your computer after the repair process is finished.
Windows 7
- Select Start, then select Control Panel.
- Double-select Programs and Features.
- Select Microsoft Office 365, then select Change.
- Select Online Repair, then select Repair.
Note
You may have to restart your computer after the repair process is complete.
For an Office 2013, Office 2010, or Office 2007 installation
To repair Office 2013, Office 2010, or Office 2007, follow the steps in the following Office website topic:
If these steps do not resolve the problem, continue to Method 5.
Method 5: Turn off add-ins
Excel and COM add-in programs can also cause this problem. These two kinds of add-ins are located in different folders. For testing, disable and isolate the conflict by turning off each add-in one at a time. To do this, follow these steps:
- On the File menu, select Options, then select Add-Ins.
- In the Manage list at the bottom of the screen, select COM Add-Ins item, then select Go.
- Clear one of the add-ins in the list, then select OK.
- Restart Excel by double-selecting the icon or file name for the workbook that you are trying to open.
- If the problem persists, repeat steps 1-4, except select a different add-in in step 3.
- If the problem persists after you clear all the COM Add-ins, repeat steps 1-4, except select Excel Add-Ins in step 2, then try each of the Excel add-ins one at a time in step 3.
If Excel loads the file, the add-in you last turned off is causing the problem. If this is the case, we recommend that you visit the manufacturer's website for the add-in to learn whether an updated version of the add-in is available. If a newer version of the add-in is not available, or if you don't have to use the add-in, you can leave it turned off.
If Excel does not open the file after you turn off all the add-ins, the problem has a different cause.
If these steps do not resolve the problem, continue to Method 6.
Method 6: Disable hardware acceleration
To work around this problem, disable hardware acceleration until a fix is released by your video card manufacturer. Make sure to check regularly for updates to your video card driver.
![Microsoft Microsoft](/uploads/1/2/5/6/125674882/401432128.jpg)
To disable hardware acceleration, follow these steps:
- Start any Office 2013, 2016, 2019, or O365 program.
- On the File tab, select Options.
- In the Options dialog box, select Advanced.
- In the list of available options, select the Disable hardware graphics acceleration check box.The following screen shot shows this option in Excel.
- Select the OK button.
Note
For more information about hardware acceleration, see the following Microsoft Knowledge Base article:
2768648 - Performance and display issues in Office 2013 client applications
Method 7: Minimizing and maximizing the window
Minimizing and then maximizing the window can sometimes refresh the Excel page and cause any hidden data to appear.
- Select the minimize button in the top-right corner of the Excel sheet.
- In the task tray, right-click Excel and select your spreadsheet. (Or double click the Excel icon.)
When your sheet is maximized, your data may appear.
Method 8: Check for hidden sheets
How to update microsoft office in mac. An Excel sheet may have inadvertently been saved as a hidden document. To find out:
- Go to the View tab.
- Select Unhide.
- Choose a workbook from the list.
- Select OK.
If you still experience this problem after you try all these methods, contact Microsoft Support for additional troubleshooting help.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Summary
You may have problems when you try to save a Microsoft Excel workbook if one or more of the following conditions are true:
- You save an Excel workbook to a network drive on which you have restricted permissions.
- You save an Excel workbook to a location that does not have sufficient drive space.
- The connection to the Excel workbook is lost.
- There is a conflict with an antivirus software program.
- You save an Excel workbook that is shared.
- The 218-character path limitation is exceeded when you save an Excel workbook.
Workarounds and resolutions
The following sections include workarounds to save your workbooks and troubleshooting steps to help you find the cause of the problem. We recommend that you first try to save changes in any open Excel workbooks before you start troubleshooting.
Workarounds to save Excel workbooks
To work around this problem and try to save your work before you troubleshoot, use the following methods. Depending on the cause of the problem, you may be unable to recover the current file as-is. However, the following methods are typically successful. These methods are listed in order of format retention when you are trying to keep the original file formatting.
Note
The following methods may not save all the latest changes, formatting, and feature sets of the workbook that are specific to the version of Excel that you are using. The following methods are intended to let you obtain a usable, saved version of the file. These methods require you to save the file to your local hard disk by using a unique file name.
Method 1: Save the workbook by using a new file name
- On the File menu, select Save As.
- Save the Excel workbook by using a unique file name.
Method 2: Move the original worksheets to a new workbook
- Add a filler worksheet to your workbook. To do this, press Shift + F11.NoteThis sheet is required because there has to be at least one remaining sheet in a workbook after you move all relevant data sheets.
- Group all the worksheets (except the filler). To do this, select the first sheet, hold the Shift key, and then select the last sheet.
- Right-select the grouped sheets, and then select Move or copy.
- In the To Book list, select (New Book).
- Select OK.NoteThese steps should move the active (grouped) worksheets to a new workbook.
If your workbook contains VBA macros, copy the modules from the old workbook to the new workbook.
Method 3: Save the file as a different Excel file type
- On the File menu, select Save As.
- In the Save as Type list, select a file format other than the current file format. If you are using Microsoft Excel 2007 or a later version, save the file as .xlsx or .xlsm instead of as .xls.
Troubleshooting
To troubleshoot this problem, follow these steps in the given order.
Step 1: Try to save the workbook to another location
Try saving your notebook to another location, such as a local hard drive, a network drive, or removable drive. If you are successful, the following are possible causes of the problem:
Step 2: Try to save a new workbook to the original location
To save a new Excel file to the original location, follow these steps:
- Create an Excel workbook.
- On the File menu, select Save As.
- In the Save As dialog box, follow these steps:
- In the Save in box, select the location in which the original workbook is saved.
- In the File name box, type a name for the new file.
- Select Save.
If you can save a new workbook to the original location, the following are possible causes of the problem:
If you cannot save a new workbook to the original location, the following is a possible cause of the problem:
Am Unable To Save Or Edit Microsoft Excel For Mac Tutorial
If you have sufficient drive space, try Step 3.
Step 3: Try to save the workbook in safe mode
Restart Windows in safe mode, and then try to save the workbook to your local hard disk.
Notes
- If you use a network location to save your workbook, try to restart Windows in safe mode with network support, and then try to save.
- Windows safe mode cannot be used to troubleshoot issues in Microsoft Excel 2010 or later versions.
For more information about how to start Windows in safe mode, see Advanced startup options (including safe mode).
If the workbook saves after you restart Windows in safe mode, try to save the file again. To do this, select Save on the File menu.
If the workbook does not save (or save again) after you restart Windows in safe mode, the following are possible causes:
Causes
Third-party add-in
If the Excel file is not saved when you run Excel in Windows safe mode, the issue may be caused by a third-party add-in or by a file that is in one of the Excel startup locations. By default, these files are loaded when you start Excel.
Sometimes, third-party software vendors install custom add-ins to work with Excel. Some of these add-ins work with existing Excel features by design, and some are intended to enable a seamless transition when you are using a third-party product. Typically, these third-party add-ins do not interfere with normal Excel functionality. However, there are some exceptions. For example, Excel save conflicts have occurred because of an add-in.
To test for and eliminate the possibility that a third-party Excel add-in or file is causing an Excel save issue, start Excel in safe mode. To do this, follow these steps:
- Exit Excel.
- Select Start, and then point to Programs.
- Press Ctrl when you start Excel, and hold it until you receive a message that resembles the following:Excel has detected that you are holding down the Ctrl key. Do you want to start Excel in safe mode?
- Select Yes.
- Try to save a new Excel file, and then resave the same Excel file again.
If the file saves correctly, a custom add-in or a file that is located in an Excel startup location is most likely the cause. You must locate and remove the add-in or the file to eliminate the problem. After you determine the add-in or the file that caused the problem, contact the vendor that designed it. The vendor may have additional information about this issue and an update that does not cause the issue to occur.
For more information about Microsoft Excel safe mode, press F1 in Excel to open the Help menu, type safe modein the Search box, and then select Search to view the topic.
For more information about how to determine the folders that Excel uses during startup and additional options to disable this functionality, select the following article numbers to view the articles in the Microsoft Knowledge Base:
822107 How to use startup folders in Excel
826922 How to prevent files from opening automatically in Excel
Restricted permissions
When you save an Excel file, you must have the following permissions to the folder in which you are saving the file:
- Read permission
- Write permission
- Modify permission
- Delete permission
Note
If you do not have these permissions, the Excel save process cannot be completed.
Insufficient drive space
When you save to any medium, such as a floppy disk drive, a local hard disk, or a network drive, you must make sure that the drive has sufficient free space to enable the file to save. If the destination drive does not have sufficient space, Excel cannot complete the save operation, and you receive the following error message: Disk is Full.
For more information about this error message, select the following article numbers to view the articles in the Microsoft Knowledge Base:
214245 You receive the 'Disk is Full' error message when you save a workbook in Excel
Am Unable To Save Or Edit Microsoft Excel For Mac 2016
214073 You receive an error message when you try to save a file in Excel
Antivirus software conflict
When antivirus software is installed or is running, you may receive an error message when you try to save an existing workbook. You do not receive an error message if you try to save a new file. You may receive an error message because some antivirus programs quickly scan any new files that appear on a computer. Microsoft word error on mac. This scan can sometimes disrupt the Excel save process. This interruption may stop Excel from saving the file correctly.
File sharing conflict
If you and a second user work concurrently on a shared workbook, you may receive an error message if you and the second user try to save the file at the same time. You receive an error message because Excel cannot save the file if another instance of Excel is saving the same file.
Am Unable To Save Or Edit Microsoft Excel For Mac Update
For more information about this error message, see the following Microsoft Knowledge Base article:
Am Unable To Save Or Edit Microsoft Excel For Mac For Dummies Youtube
130494 Unlock a file that has been locked for editing
Am Unable To Save Or Edit Microsoft Excel For Mac Free
File name length
If you try to save or open an Excel file, and the path of that file (including the file name) is more than 218 characters, you may receive the following error message: Filename is not valid.
For more information, select the following article number to view the article in the Microsoft Knowledge Base: 213983 Error message when you open or save a file in Microsoft Excel: 'Filename is not valid'
Am Unable To Save Or Edit Microsoft Excel For Mac Pro
Process to save a file
Excel follows these steps when it saves a file:
- Excel creates a randomly named temporary file (for example, Cedd4100 without a file name extension) in the destination folder that you specified in the Save As dialog box. The whole workbook is written to the temporary file.
- If changes are being saved to an existing file, Excel deletes the original file.
- Excel renames the temporary file. Excel gives the temporary file the file name that you specified (such as Book1.xls) in the Save As dialog box.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
814068 Description of the way that Excel saves files
Note
Other processes that occur on your computer may disrupt the Excel save process. These issues may occur if the Excel temporary file is accessed before the Excel save process is completed. For example, the local antivirus software locks the temporary file for scanning before the file can be renamed. Therefore, you must keep track of any new software installations or updates that are performed before you have problems when you try to save workbooks. This information will be helpful if this article does not fix your issue and you have to contact Microsoft Support. For more information, go to the following Microsoft website: http:/support.microsoft.com