In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds:
In the Excel add-in, refreshing is all-or-nothing: you can refresh a single sheet on its own, or refresh every sheet in the workbook. There's no way to pick a subset.
Example: one of my FP&A users has a workbook with 10 connections, and on a typical day only about half of them should be refreshed. The other five need to stay exactly as they are - they hold figures that have already been reviewed or submitted, so refreshing them would pull in new data and change numbers that are supposed to be locked down. The only option is to go sheet by sheet and refresh five connections one at a time, several times a day. In the classic Anaplan plugin they could simply tick the connections they wanted and refresh just those in one go, so this feels like a step backwards for anyone migrating over.
How often is this impacting your users?
Daily. This is hitting my FP&A users. Any time a model is updated they need to pull fresh data into the specific sheets they're working on while leaving the rest untouched, so it comes up several times a day for that team.
Who is this impacting?
Business/end users - specifically our FP&A team, who work in large reporting workbooks where some connections must be refreshed and others have to stay frozen. More broadly it affects anyone using the Excel add-in with more than a couple of connections in a workbook.
What would your ideal solution be? How would it add value to your current experience?
A refresh option that lists all the sheets/connections in the workbook with checkboxes, so users can select any combination and refresh only those, with everything left unticked guaranteed to stay untouched - the same way the classic plugin worked. Being able to save a named selection for refreshes that are run regularly would be a bonus.
The value is control first, speed second: users could update exactly the connections they need while being certain the rest stay static, instead of trading that off against a long manual sheet-by-sheet process. On top of that it means quicker refreshes on large workbooks and less unnecessary load on the model, and it closes a gap against the classic plugin, which would make it much easier to move our FP&A users onto the new add-in.
