MS word has a feature where you can copy remotely stored files onto your
computer, and update the remote file when saving.

Does Excel have such a feature?

We have network shares where people have write access to a file so Excel is
not able to delete the temporary files when it closes.