Is there an easy way to see all the cross sheet references for a given sheet

I'm looking to scale back the number of cross sheet references I have in a sheet as I've hit the new 100,000 cell limit. I'm hoping there is a statistics or some information that I can look at to see where all the references are and possible cell counts that are being used so that I can make an informed decision on what and how to simplify the sheet.

I'd rather not try to inspects each cell and manually go through all of them to find out where they all the references are.

Thanks

Best Answer

Answers