use event code. rightclick excel icon on the left of "file" in menubar and click view code.
on the left side arrow choose workbook on the risht side arrow choose sheetchange.
write your code.something like this
workbooks(...).save
the first you save manually.
note that the file will be saved everytime you change any cell in any sheet. you can restrict his to change in cells in a range in particulr sheet.