如何自动刷新Excel公式? [英] How to automatically refresh excel formulas?
问题描述
我遇到使用ExcelPackage大问题,因为有时公式不更新(即使我删除值)。
I'm experiencing big problems using ExcelPackage, because sometimes the formulas are not updated (even if I remove the value).
我用ExcelInterop保存XLSX为XLS,以为这样可以解决问题试过了,但事实并非如此。
I've tried using ExcelInterop to save xlsx as xls, thinking that this could resolve the issue, but it didn't.
我发现要解决它是由pressing Ctrl + Alt + F9的方式。用户不喜欢做它每次,所以,我想以编程方式做到这一点。你知道任何有效的方法,以确保所有的xlsx公式更新?
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?
推荐答案
呼叫 Application.CalculateFull 从VBA宏(或通过COM对象)
Call Application.CalculateFull from a VBA macro (or over the COM object)
这篇关于如何自动刷新Excel公式?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!