Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to automatically refresh excel formulas?

Tags:

c#

.net

excel

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?

like image 305
Victor Rodrigues Avatar asked Nov 29 '22 19:11

Victor Rodrigues


1 Answers

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

like image 61
Scoregraphic Avatar answered Dec 05 '22 17:12

Scoregraphic