View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
 
Posts: 258
Default Automatic recalculation of array functions

Hi Schiz,

CTRL + ALT + F9 forces the recalculation?

By the way, my custom array formulas recalculate while changing any
value of precedent cells (on other worksheets), even if not volatile.

But maybe setting it to volatile could help.

Regards,
Ivan