July 29, 2020
I have some spreadsheets that have a bunch of logic defined in the sheet. I want to convert this sheet to an addin and write some vba routines to create a "wrapper" for the spreadsheet. The wrapper functions that I will call from other spreadsheets will take the parameters passed in, update corresponding cells in the addin, update the calculations and then return a value back. There seems to be issues with sheet calculation in the addin - it won't calculate.
This is actually quite powerfull if it would work as you can encapsulate behaviour for an entire worksheet that is callable from a vba function in the addin. Pass the information in - run calculations, return any number of results through vba functions that get the values of specific calculated cells.
I am wondering is there are additional excel api calls that I need to be doing to enable calculation of worksheet cells in the addin?
November 8, 2013
Hard to say without seeing how the functions are built.
For example, a function will not work if the function itself is supposed to change a value in a cell.
You can add Application.Volatile to your vba functions, if they are supposed to update at each recalculation.
Last, Application.CalculateFull should recalculate every open workbook, including addins.