Cant Save Microsoft Excel File

Below are the steps depending on the version of Microsoft Office you are using.

  1. Can't Save Microsoft Excel File Could Not Open In Protected View
  2. Cant Save Microsoft Excel Files
  3. Microsoft Excel File Extension

Office 2016¶

Present in Office Word, Excel, and PowerPoint programs, the AutoSave feature automatically saves your documents every few seconds, as you work on a file. While the AutoSave feature is fantastic and is enabled by default, many users often complain that the AutoSave is disabled or can’t turn on the AutoSave feature in Word, Excel,. W10 18362.449 Office 2016. I can open a excel file that sits on my desktop, change something and Excel will not allow me to Save As or Save it back to its original position or any other location on the C: Can save to another drive without issue.

In Excel 2016 you can now choose to save a CSV file with UTF-8 directly:

Cant Save Microsoft Excel File

Can't Save Microsoft Excel File Could Not Open In Protected View

  1. Click File then Save As
  2. In the “Save As” window choose Browse
  3. In the “Save As” dialog click the Save as type drop down
  4. Select the “CSV UTF-8 (comma delimited) (*.csv)” option
  5. Click the Save button

Office 2013 and older¶

Older versions of Excel dont have an encoding option so follow the steps below:

  1. Right click the file and select “Open With Notepad”
  2. Click File
  3. Click Save As
  4. In the “Save As” dialog click the Encoding drop down
  5. Select the “UTF-8” option
  6. Click the Save button

Raul Prieto writes in with an asymmetrical issue:

All of a sudden when I am trying to save a modified file with a different name in Excel in the same folder than the original, I get the attached reply [see figure] and cannot save it.

I checked in with Raul via email about whether the filename had a / (forward slash) in the name—it did! He was able to change the name in the Finder and save the file. While I wrote about problems saving files in Yosemite, this is unrelated—it’s not a permissions issue, either.

This is a very, very, very long-running problem that seems to crop up only with Microsoft apps. Create a file in any other program, put a slash in its name, save it, open it, modify it, and save it again. OS X handles it just fine. Do the same with a Word, Excel, or PowerPoint document and you receive an error.

File

Cant Save Microsoft Excel Files

Cant Save Microsoft Excel File

Microsoft Excel File Extension

Just rename the file and you’re back in business.

Ask Mac 911

We’ve compiled a list of the most commonly asked questions we get, and the answers to them: read our super FAQ to see if you’re covered. If not, we’re always looking for new problems to solve! Email yours to mac911@macworld.com including screen captures as appropriate. Mac 911 cannot reply to email with troubleshooting advice nor can we publish answers to every question.