In the past when I have had to do this I create a 'SAVE' button at the top of
the sheet. i then record a simple macro that saves the file to the local
computer and then saves the file to the server. I then attach the macro to
the save button. Then when I want to save I click the Save button on the
spreadsheet and it saves in both places.

"Saving a Backup every time" wrote:

I need to make a backup onto a server for every file I save. Is there a way
I can have excel save 2 copies - one where I have access, and one in the
backup file in my server?