Temporary stored files during saving Excel file cannot be deleted on NAS - .xlsx.sb
since the update to Mojave, Excel documents store repeatedly (not all files) temporary folders which are not deleted on NAS when one opens them with Microsoft Office 2016. This behavior seems related to the content within the Excel files. It looks like that as long as no diagram is saved in the Excel document the associated temporary file will be deleted as intended.
But if diagrams ore a more complex document structure is being created in the documents, then apparently not only temporary documents but folders are created during saving. After closing the document, you can no longer delete the temporary folder via the Finder as they do not vanish automatically anymore. The names of the temporary files are always similar:
The deletion can only be done manually via the NAS interface. This behavior did not exist in 10.13 and SMB connections are available from SMB1 - SMB3.
How can one fix this? The rights have not been changed and are designed for reading and writing on the NAS. Does anyone know help? I've googled a lot, but the solutions do not work with our NAS.
Storing the files from Windows will work fine.
In some cases, it was suggested to change the permissions on the file server, but I do not that these right will differ from the suggested rights:
sudo chmod -R 777 .TemporaryItems/
sudo chmod -R 777 .Trashes/
Response from Synology:
Thank you for your inquiry with Synology and we will gladly assist you.
The problem is known as a workaround, please manually remove the temporary file until the problem is resolved.
The problem is well-known and they nevertheless leave their own customers frustratedly searching for solutions for which they have no solution, too!
Is a manual deletion any alternative? How should this work in a company: Anyone who creates an Excel document should contact the administrator afterwards to manually delete the temporary files? And no advice on the Synology website about that?...
That's really outstanding ...