Have created a workbook with the "working" data and a second workbook with KPM monitoring. All information in the KPM spreadsheet is pulling from the "working" data - however, the links will not update when opening the KPM spreadsheet. Also, when trying to enter a new formula..... =COUNTIFS( ) when clicking in "working" spreadsheet, the formula doesn't pick up the link (click). How do I correct this issue?