Volatile Functions

[MWS]

I have a rather large Excel based model which is starting to run sluggishly. I use OFFSET within the model and suspect that it may be the main culprit, but before I make any structural changes, my question is: Does the use of pivot table slicers trigger volatile related sluggishness?

Any insight would be greatly appreciated.

PS - This site is an excellent resource!!!

Thank You

 

[Chihiro]

Yes, slicer selection change (i.e. pivottable update) will trigger volatile functions to recalculate.

 

[MWS]

Thank You Chihiro!

 

[pecoflyer]

If you are using OFFSET for a dynamic range, try an INDEX/MATCH combination which is not volatile

 

[MWS]

If you are using OFFSET for a dynamic range, try an INDEX/MATCH combination which is not volatile

Thank You for the insight, I will give it a try. Much APpreciated!!!