Guys! Excel crashes every 15 mins or more! It's almost unusable and I have to use it. It ridiculous how bad it is. I shouldn't have had to pay money for this and it makes my job 10x harder. Please fix it. For the amount of money I paid for office (and excel) it should be a working program. Right now Microsoft is a thief of my money and time with the amount of times I've had to redo work with all the crashes. I don't want to hear how you fixed it, just fix it!! (yes, I've updated the program)

I am using Excel for Mac, version 16.30 (always updated to the latest version)

I can easily obtain stock quotes all index members of the Dow Jones, Hang Seng Index, Swiss Market Index. Also to retrieve the index quotes for DJIA, S&P500, DAX, etc. is not an issue at all.

Obtaining the quote for the Hang Seng Index itself I haven't figured out for a couple of months already.

“HSI” returns "H.I.S. Co Ltd (OTCM:HISJF)” “Hang Seng” returns “No results found for Hang Seng” “^HSI” returns results such as H-Source Holdings, etc.

I have reached out to Microsoft calling the hotline in Shanghai, approaching Microsoft through its Facebook page in Hong Kong, but all failed, as I believe the support team fails to grasp the question (what is a stock, what is an index, etc).

Also requests to speak to technical person with knowledge of the Stocks module remains unanswered.

How is best to approach Microsoft to have this resolved?

I am using Excel for Mac, version 16.30 (always updated to the latest version)

I can easily obtain stock quotes all index members of the Dow Jones, Hang Seng Index, Swiss Market Index. Also to retrieve the index quotes for DJIA, S&P500, DAX, etc. is not an issue at all.

Obtaining the quote for the Hang Seng Index itself I haven't figured out for a couple of months already.

“HSI” returns "H.I.S. Co Ltd (OTCM:HISJF)” “Hang Seng” returns “No results found for Hang Seng” “^HSI” returns results such as H-Source Holdings, etc.

I have reached out to Microsoft calling the hotline in Shanghai, approaching Microsoft through its Facebook page in Hong Kong, but all failed, as I believe the support team fails to grasp the question (what is a stock, what is an index, etc).

Also requests to speak to technical person with knowledge of the Stocks module remains unanswered.

How is best to approach Microsoft to have this resolved?

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:

nameoffolder.xlsx.sb-yyyyyyyy-xxxxxx

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.

Thanks,

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:

cd /Volumes/YourServerVolume/
sudo chmod -R 777 .TemporaryItems/
sudo chmod -R 777 .Trashes/