Ability to change switch models in the excel add in

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.

Master Anaplanner/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: Your support is needed
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)

Certified Master Anaplanner

I am glad to announce that we are working on this 😀
Well done on supporting this idea!

Status changed to: On Roadmap
Certified Master Anaplanner

If you would like to see prototypes of this idea, join our add-in feedback group and sign up to a session about the future Excel add-in 4.0.

Certified Master Anaplanner
Status changed to: Delivered
Users Online
Currently online: 195 members 806 guests
Please welcome our newest community members: