changes any excel causes an excel's function execution

Question

I have encountered an excel that has very strange behavior for me.

if I change any cell value any other excel, it causes to execute all the user-defined funcion in this strange excel.

I realized it by debugging macro.

I couldn't figure out which settings or statement causes this.

Any idea?

For UDFs, look in to [Application.Volatile](https://msdn.microsoft.com/en-us/vba/excel-vba/articles/application-volatile-method-excel) — BruceWayne, Apr 05 '18 at 22:38

score 0 · Answer 1 · answered Apr 05 '18 at 23:28

0

I too have noticed UDFs recalculating unexpectedly. See my question and answers/comments at Need to stop UDFs recalculating when unrelated cells deleted

Because of this, I now steer clear of UDFs in favor of Excel formula combinations whenever I can.

answered Apr 05 '18 at 23:28

jeffreyweir

1 Answers1