Excel Add-in: Ability to detect if columns have become unlinked via named ranges

As an end user It would be useful to be notified when a column becomes unlinked from Anaplan and is no longer being updated. Currently this can be done by searching what is contained in the named range “AnaplanColHeader“.

Screenshot 2020-04-09 at 12.19.37.png

Note: LI1 has become unlinked and will not update on refresh.

This could be done via a pop up that detects If there are any columns that do not fall under the “AnaplanColHeader“ range and notifies the user and/or fixes this automatically upon refresh.

Comments

Miran

Status changed to: New

Quick Links

New ideas

Administration Console: Keep Last login in Date format, on top of new format
It is great to know how old is the Last Login, but: 1.It would be great to keep the old Date format as well, to be able to make more easily some ad hoc analysis (older than X days, months etc…, as shown in example further below). The filter on new format is not possible and would not be meaningfull. 2.It would be great to…
Synchronized Scroll on Worksheet with an Expanded Grid Card
It would be incredibly helpful to have the ability to group the main worksheet grid with an expanded card for synchronized horizontal scrolling. Use Case: In my worksheet, I have the Time dimension on columns and a list on rows in the main grid. I also use an expanded grid card to show a different breakdown—still by Time,…
Line Item Spacing within a Text Box
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: Option to adjust line spacing within a text box. Who is this impacting? (ex. model builders, solution architects, partners, admins,…