After the last AVG update I can no longer save my old Excel files, if I created new ones, those can be saved. I am getting this message: When saving a file, a sharing violation can be caused by the way an antivirus application interacts with Microsoft Office. This Microsoft Excel 2016 tutorial shows you how to save an excel workbook. When saving a file, you need to know the difference between Save and Save As.
Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
A file is blocked when you open or save the file in a Microsoft Office program. In this situation, you may receive an error message that resembles one of the following:
- You are attempting to open a file that is blocked by your registry policy setting.
- You are attempting to open a file type <File Type> that has been blocked by your File Block settings in the Trust Center.
- You are attempting to open a file that was created in an earlier version of Microsoft Office. This file type is blocked from opening in this version by your registry policy setting.
- You are attempting to save a file that is blocked by your registry policy setting.
- You are attempting to save a file type <File Type> that has been blocked by your File Block settings in the Trust Center.
Resolution
To resolve this issue, try the following general resolutions to change the File Block settings to disable the restriction of certain file types:
Select File > Options.
If you cannot open a file in Office, open a blank document to start the Office application. For example, if you cannot open a Word file, open a new document in Word 2019 or Word 2016 to see the option.
In the Options window, select Trust Center > Trust Center Settings.
In the Trust Center window, select File Block Settings, and then clear the 'Open' or 'Save' check box for the file type that you want to open or save.
Note
Clear the option means allow user to open or save the file. Check the option means block the file.
Select OK two times.
Try to open or save the file that was blocked again.
Note
The File Block Settings can be controlled by a Group Policy Object (GPO) and are part of the recommended security base line settings. Enabling a file type that's blocked by default could compromise security.
Here's how to open the GPO:
Open the Group Policy Management Console.
Navigate to the following GPO:
User ConfigurationAdministrative TemplatesMicrosoft <Product Name><Product Name> OptionsSecurityTrust CenterFile Block Settings
Replace <Product Name> with the affected Office application name, for example Word 2019.
You may also have to download Administrative Template files to use the GPO.
More information
The issue can also occur when you open an embedded or linked Office file in an Office application. For example, you have a Visio object embedded in a Word document. When you try to open the Visio object, you receive a similar error message in Word. To resolve this issue, you must change the File Block settings in the application that owns the blocked file type. In this example, you must change the File Block settings in Visio instead of in Word. If the error message mentions Excel file type, go to Excel to change the File Block settings.
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.
Just rename the file and you’re back in business.
Ask Mac 911
Cant Save Microsoft Excel File Instead
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.