Ability to change switch models in the excel add in

moment when you set up an spreadsheet reports pack via the excel add in you select a model to work from and are not able to change this.  I would like to be able to change the model you look up to without having to rebuild the reports pack.


We have a medium sized reports pack that works in the excel add in taking a lot of data from Anaplan and populating various spreadsheets that are used as reports on the model.  I have recently run a slightly different scenario by copying the live model and making some changes to my assumptions (the design of the model remains the same just some assumptions on things like when we start construction and how many sites we will buy next year).  however I am not able to provide the usual reports unless I rebuild the reports packs from scratch.  It would be much more efficient if I could just change the model that the 7 or so Anaplan reports look up to and refresh the workbook rather than have to spend a lot of time rebuilding this from scratch each time I run a new scenario.  I appreciate that this could cause issues if users are trying to switch the link to models which have different designs / dimensions but it would be useful for this kind of scenario modelling.

Community Boss

I also think it would be a useful enhancement to the excel add-in to refresh data from a different model if the model is structurally compatible with the current model connection, as Richard suggests!

Community Manager
Status changed to: Needs Community Support
Certified Master Anaplanner

Yes, this is a very useful feature. Maybe we can achieve it by having the connection details as a Named Range?

New Contributor

Agree, this would be very useful if this is still seeking community support

Occasional Contributor

Yes definitely still seeking community support as would be very useful for us (and a lot of time saved)

Users Online
Currently online: 62 members 344 guests
Please welcome our newest community members: