Count of cross-sheet formulas in a sheet
Given the limit of 100 cross-sheet references per sheet, is there any way of seeing the total number of cross-sheet references already in place for a given sheet?
My use case - I've got a handful of sheets reaching the maximum amount on each, all to support rollup metrics for executive reporting. My formulas are lengthy and involve multiple references. I've repeatedly encountered the maximum in the course of writing these formulas.
Seeing a total before modifying formulas would help me know whether I should write my formula on another sheet (and leverage cell links) in order to avoid this limit.