Unique cells referenced in cross-sheet formulas Limit - How is this calculated?

Lucas Rayala

Hi @Genevieve P., I use Index/Collect or Index/Match and I'm careful to keep references to a minimum. There are just instances where the theoretical counts of cells referenced (either internal to the page or external to the page) don't trigger the warnings I would expect. I have a colleague who has a page with far to many references to other pages and it's not triggering warnings, and I've been trying to puzzle out why.