I have a cell link to another sheet. ( links are generated from Control Center) On several occasions, when the timeline date changes (source sheet), the link to the summary sheet does not update. When you are in the summary sheet and you double click on the cell, the source sheet pops up showing the correct data (date) , but the summary sheet doesn't update.
My solution when this happens is to change the link, then change it back to the original cell link and then all is good.
It has happened a hand full of times in the past year. Even thought it is infrequent, when it does happen reporting for critical dates are being missed.
Has anyone else run into this ?