A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Re. Catalina. We have users on pre-Catalina versions of Mac OS and they report the same problems as those of us on Catalina.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Since installing Catalina 10.15 and Office 365 16.30 (updates installed the same day (something I will not due again)) when I attempt to save a workbook that I have used for a couple of years, I receive the alert: 'Your changes could not be saved to xxx.xlsx due to a sharing violation. I then receive the alert The file format end extension of 646820000.mactf don't match.
I contacted the Answer Desk who say it is an Apple Product and Apple support said it is a Microsoft problem.
Any thoughts or suggestions will be appreciated.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Re. Catalina. We have users on pre-Catalina versions of Mac OS and they report the same problems as those of us on Catalina.
@Lordsaveme thank you for your suggestions, but i have no time for extensive testing...if i can roll back to 16.29 i will prefer doing that.
@srd77 how did you roll back?
@antonioj.f Previous install packages are available here: https://docs.microsoft.com/en-us/officeupdates/update-history-office-for-mac
Uninstall your current version (although Excel was the main offender I ditched the whole suite), then install 16.29. I had success by removing just the applications, with no need for a 'deep clean' of related files.
@Lordsaveme I assumed it was a permissions issue (we have plenty of these on our mixed-environment network) but after lots of testing came to the conclusion that, for once, the cause lay elsewhere.
Reverting back to 16.29 had been working for me for the past few months but last week even that failed (Sharing violation alert , followed by save as *.MACTF, ...). So I've updated to the latest version of Excel (16.33, 20011301) which still has the problem.
When I first upgraded to 16.33 I did not have the option to grant Full Disk Access, or even Network Access but a few days ago that option appeared, although there’s still no option available to grant Network Access nor to manually add it (i.e., the “+” icon is grayed out). After granting Full Disk Access to excel the problem went away for about a day but now has returned.
This error only occurs when attempting to save to my Synology NAS and only Excel files have the problem. NO problem saving too the NAS with any other programs such as Adobe Lightroom or even Word. Some of the Excel files are edited by one other user, many just by me. My current workaround is to open Excel files from the NAS, make my changes, save as to a local folder, then use finder to copy the file back onto the NAS.
I believe this began before upgrading to macOS Catalina, with no change when I finally did upgrade to Catalina.
I’m headed out of town and until I return will not be able to add to look into the OSX solution LordSaveMe has proposed (the NAS is on a local network). However er, it sure seems to me to be an Excel problem and wish Microsoft would fix this problem! Especially since jacsdad was able to get support to duplicate the problem and they promised a fix would be made several months ago.
Thanks
-Ray
Figured out how to roll back to 16.29, and it does work! I also will be sticking with it until someone reports there are no more problems!
@Lordsaveme thank you for your suggestions, but i have no time for extensive testing...if i can roll back to 16.29 i will prefer doing that.
@srd77 how did you roll back?