Formula only updating when I click on it

I have the following code that runs the "MySum" custom function. The only way it updates is for me to click in formula and hit enter. The "Calculation Options" is set to auto. I've added

Application.CalculateFull

but no luck. I can't upload due to corporate policy. Any help will be grateful

=IFERROR(MySum("Parts",0),"")