Excel refreshing formulas

Have you tried attaching a simple Macro to the file and calling that?

recalculate all open workbooks
Application.Calculate

recalculate a specific worksheet
Worksheets(1).Calculate

recalculate a specific range
Worksheets(1).Columns(1).Calculate