Macro to automatically update formula results

[dsrt16]

I have a bunch of formulas referencing cells in another workbook.

Cells A5:A33 reference another workbook's data. I have used the pull formula since the workbook it is referencing will not necessarily be open.

The formulas all work. However, when I make a change in the reference workbook, when I open the workbook with the formulas the change is not automatically there. I have to go into the cell and click enter to manually cause the formula to run and check for updates.

Is there a macro I could write to automatically check to see if any of the results to the formulas have changed.

 

[Trevor G]

Have you checked to see if autoCalculate is switched On? you could add the following:

Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate