c# - How to automatically refresh excel formulas?

Question

I'm experiencing big problems using ExcelPackage, because sometimes the formulas are not updated (even if I remove the value).

I've tried using ExcelInterop to save xlsx as xls, thinking that this could resolve the issue, but it didn't.

The way I've found to resolve it is by pressing CTRL + ALT + F9. The user will not like doing it everytime, so, I want to do it programatically. Do you know any effective way to ensure all xlsx formulas are updated?

Answer 1

Call Application.CalculateFull from a VBA macro (or over the COM object)