Avatar of tmartin40
tmartin40
Flag for United States of America asked on

Excel crashes when Mac goes to sleep

I have a group of four users experiencing the same problem.  They are all using Macs running High Sierra and Office 365.  Additionally, these macs are connected to a Windows 2012 R2 server for file sharing.  Although the problem happens periodically in other applications the primary issue is when they are using Excel.  

User can open an Excel file from the network share and work on it and save it unless the computer goes to sleep.  If, for whatever reason, the computer is idle with the file open and goes to sleep, the file becomes corrupt somehow and they cannot save it.  I've tried to save it back to the share and to other locations (i.e. desktop) but it does not work.  Basically the file will not save anywhere.  As long as it is open, they can continue to work in the excel document, they just can't save it.  They receive an error similar to the attached image.Excel Error
Microsoft OfficeMicrosoft 365Mac OS X

Avatar of undefined
Last Comment
tmartin40

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
serialband

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
tmartin40

ASKER
When the save failed but the file was still open, I tried save and save as.  Tried saving it (using save as) to different locations.  It just didn't work.  As I am not a Mac guy, I am a little confused.  Are you saying that running "defaults write com.apple.desktopservices DSDontWriteNetworkStores -bool TRUE" from terminal on all user machines (there are four of them), this will solve the problem?

I had someone else tell me to install "Automounter" and this would solve my problem.  Have you ever heard of this?
serialband

No, the DSDontWriteNetworkStores will mainly prevent Mac user contention when accessing the same folders, so they don't try to write the .DS_Store folders at the same time.

Automount is a built-in (unix) function

https://useyourloaf.com/blog/using-the-mac-os-x-automounter/
tmartin40

ASKER
okay thanks.  I appreciate the help.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23