Sharing Violation on Mac Sonoma 14.3

Nina Tersigni 0 Reputation points
2024-02-09T20:56:20.63+00:00

Hi, I just recently did a software update on my Mac to Sonoma version 14.3. I have an excel file that uses macros, when that file is on my desktop it doesn't work properly, I get a Description: Your changes could not be saves because of a sharing violation. I tried saving it under a different name, it doesn't work. I put that same on a usb and opened it from the usb and everything works perfectly. I uninstalled Microsoft 365 and reinstalled it, the issues still remains. Everything was working perfectly until the new software update was installed. I contacted apple and they are saying it Microsoft and Microsoft is saying its apple.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,217 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
481 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
    2024-02-12T07:49:40.1+00:00

    Hi,

    Did this problem appear in all Excel Workbooks or specific Workbook?

    I suggest you check if you have enabled all macros in Excel:

    1. Click the Excel menu as appropriate.
    2. Click Preferences
    3. Click Security & Privacy
      • To allow all macros to run select the Enable all macros radio button.

    Try this method and check if you can save Workbooks without problem.

    If the response is helpful, please click "Accept Answer" and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.