First I want to describe the environment:
Windows Server 2016 (holds the network SMB share folder)
Mac OS X (El Capitan/Sierra), all users use that and have FULL ACCESS to the network-share root and all subfolders etc. They are not in the domain, but use all the same credentials to connect to the network-shares. The use a software that isn't compatible with with the newest MAC OS.
Now to the problem:
When users access an excel file on the network-share, they cannot save it again under the same name. They can delete the files, rename them, move them etc. So right now they have to open an excel file, save it under a different name, delete the previous one and then rename the new one back to the old one. It's not super bad, but pretty annoying. Other Office Software products work as intended (Word, Powerpoint and so on), only Excel causing this issue.
What have I tried/checked so far:
- Made sure that .temporaryitems in the network-share root gives full access to the users.
- Made sure that nobody else was accessing the same file that I was using
- Disabled auto-save function in Excel
- Disabled .DS_Store creation on network shares
What is the error-message:
Couldn't save it under bla.xlsx, saved the file as [random hexa-decimal filename with about 8 digits]. (Note: That file can than be found in the .temporaryitems folder)
Solutions that my boss wont accept:
- Change network share to cifs or afp instead of smb (Reasons behind it don't matter)
Workaround that I thought of, but my boss isn't too happy about:
- Created a network share (smb) on their NAS. Works perfect there. Boss complains that it wont be included within the backups. So I thought just create a VM on the server and back that up. Boss is somewhat ok with it, but would prefer a solution without a workaround.
I might have forgotten things that I've tried, because the initial error messages and error behaviour were FUBAR, and I adjusted the settings to now look as described above.
Fyi, if I save an excel file under a new name, I can save it under the same name again as often as I want, unless I close the file. After closing the file and reopening it, the "fun" begins.