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
1 votes

New · Last Updated

Comments

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Get Started with Idea Exchange


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



Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In