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“.

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.