Excel vba sharing violation after updating to os x 10.15.7

I have an Excel vba script that creates a new workbook then saves it with a new name. The script was working fine until I upgraded to 10.15.7. Now it gives me a 1004 sharing violation error. Appreciate any ideas.

Thanks,

Tony

MacBook Pro 15″, macOS 10.15

Posted on Sep 25, 2021 11:03 AM

Similar questions

Sharing Violation in Microsoft Excel since Update Hi, I've been receiving a sharing violation notification in Microsoft Excel since upgrading to the latest OS and the latest version of Microsoft Excel. This issue only occurs in Microsoft Excel files containing a VBA macro which are saved into my Google Drive File Stream. Eight out of ten times my files will operate fine since the update to the latest OS, but on the two times which it doesn't, I receive these sharing violation notifications and cannot save my work. How can I fix this? Why is this happening?
1186 1
Troubleshoot FCPX 10.3 on a MBP 8,2 On a favorite old laptop (MBP 8,2 running 10.11), my FCPX 10.3.4 has quit the share function. I can get the drop-down menu of destinations, but none of them response for a request to share. Except for that, everything else on this app runs fine. Is there some preference file which has gotten corrupted and needs replacing? I do have the option of a new installation of the app, as outlined by Luis Sequiera1 There's another possibility: Most of this app's work has been on a long-running, continuous run of additions to several libraries. Maybe the sheer number of these is clogging up the available RAM. I have shared all the existing projects out to either DVD or Master File, so tossing all these libraries would not be a disaster. TIA
895 6
"Could not load sharing preference pane"?? MacBook 2019 MacOS Monterey 12.1 Hello! If I choose Sharing in System preferences I get this message. Can anyone support me? Ciao, Chiara
4166 2

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Excel vba sharing violation after updating to os x 10.15.7

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up