A macro-enabled excel file can save automatically when changing any cell value. See the below given VBA code for autosave :

1. Right-click the sheet tab that you want to autosave the workbook after entering new data, and then choose View Code from the context menu, in the opened Microsoft Visual Basic for Applications window, copy and paste the following code into the blank Module:

Private Sub Worksheet_Change(ByVal Target As Range)    
If Not Intersect(Target, Me.Range("A1:AA1000")) Is Nothing  Then        
ThisWorkbook.Save    
End If
End Sub
Note: In the above code, A1:AA1000 is the cell range which you want to apply this code.

2. And then save and close this code window, now, when you update or enter new data into the specific worksheet cells, the workbook will be saved automatically without clicking Save button.



Reference: https://www.extendoffice.com