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

0 Kudos

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 Comment
Community Manager
 
Status changed to: Your support is needed
Users Online
Currently online: 74 members 383 guests
Please welcome our newest community members: