Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
55
Restoring user define formulas on load
posted

Hi,

I'm registering some custom simple formulas using workbook.RegisterUserDefinedFunction(formula). The workbook is then saved (in Excel2007 format). When the workbook is loaded again as a new workbook and the formulas registered on that workbook the formulas aren't connected/active. They do become active when individually reapplied to each of the cells they are used in but this is nasty and problematic. I can imagine that not having foreknowledge of the formulas during loading might result in this behaviour but it's really not very useful. So the question is: how can I register the user defined formulas so that they are active when the workbook is loaded? (using 17.1)

Thanks

Parents Reply Children
No Data