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.

1 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!