Excel user defined functions

dermot

If my Excel model has user defined functions, ie multiline VBA functions that are called by worksheet cells, can Anaplan handle them?

I could not find anything about them online

 

thank you

dermot

Thank you for that answer, Jared

The situation is that this organisation is in the process of purchasing Anaplan, and I am assisting in the redesign of an existing Excel forecasting model. I want to do this in a way that will make it easy to integrate with Anaplan in the future. However, at the moment, it seems to be hard to get any specific information about Anaplan until the purchase is completed, hence my question.

If you are saying that the Anaplan add-in hooks into Excel, and so you can use Excel normally, but have access to various Anaplan functions (or maybe it's the other way round and Anaplan has access to Excel and can run it for you), then that makes things pretty straightforward. I think Excel will need to continue to be used because there are quite a few exceptions and oddball situations that have to regularly be catered for.

So it sounds as though I can plan the Excel model as normal, and then integrate things like data collection with Anaplan later on.

(wrt raising functions, normally one would include the line Application.Volatile at the start of a user defined function, which forces recalc every time Excel recalculates)..

Thank you again for helping me understand this.

dermot

Thanks for the assistance, Jared, much appreciated

I think I know enough to keep going and I can learn more once Anaplan is available to us

 

Which answers my question,

dermot