Auto update formula every minute

Add the below code in ThisWorkbook Code Window

1. Copy the code that you want to use
2. Select the workbook in which you want to store the code
3. Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
4. In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
5. Right-click on the ThisWorkbook object, and choose View Code
6. Where the cursor is flashing, choose Edit | Paste

Private Sub Workbook_Open()
    Call SheduleTask
End Sub

Add the below code in a Module of that workbook

To Add Excel VBA Code to a Workbook / This Workbook Module

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Sub CalculateMe()
Dim Ws As Worksheet

Set Ws = ThisWorkbook.Worksheets("Sheet1")
Ws.Calculate
Call SheduleTask

End Sub

Sub SheduleTask()
    Application.OnTime Now + TimeValue("00:01:00"), "CalculateMe"
End Sub

Glad it helps you and thanks for the feedback and rep