Formulas with vba calls are not always recalculated
Posted on 2013-06-24
I have an application with several sheets where the user input data. The data on those sheets are summarized on several sheets and instead of using standard functions like =sum etc, vba code is used.
If the user activates a summary sheet, the worksheet_activate event is used to recalculate the sheet. But often but not always, the vba code is not executed.
The call to vba code have no links to the other sheets, just range or byval parameters that have data from the activesheet.
How to work around this so that the vba code is always executed in the formulas? Anything to set?
The CalculateFull method seems to work better but it slows down the application a lot since all seems to be executed.
I have tried both the automatic calculation to be turned on or off.
Thanks in advance.