How to fix temp file issue?

I have noticed a scenario: 

When an Excel file is opened in edit mode inside a Windows share, it generates a temporary file. After some time, if the network gets disconnected and then reconnects, and the Excel file is closed, the temporary file ($xxx.xlsx) will disappear after few minutes.

However, 

in a client-server  setup,  when a  client tries to access an Excel  file on the server in edit mode,  it also  generates a temporary file. After some time, if the network gets disconnected and then reconnects, and the Excel file is closed, the temporary file ($xxx.xlsx) remains and does not disappear.

Why is there a difference? Temporary files are generated in both cases, but they are automatically deleted in one case, while in the other, they remain.

How can we automatically delete these files in a client-server environment during a network loss?