C# - Force Excel to ReCalc before Save

Question

Good Morning Overflow-ers!

I have been writing an agent which will open an Excel file, modify two cells and then save the workbook as well as a copy of this workbook.

What I really need is for just before the save, my agent to force a recalc on the whole workbook, so that all of my queries (which are in formula bars due to an inhouse add-in) re-run and get the latest values from an SQL Database.

If anyone could make any suggestions on this, that would be much appreciated.

Many Thanks

Answer 1

MSDN : http://msdn.microsoft.com/en-us/library/2kseswtc.aspx

Answer 2

In theory, just xlApp.Calculate() should do the trick, based on the documentation.