100,000 cell reference limit - do I understand it right and can I monitor it?

Gita Mooney

@Genevieve P.

The columns being added in the sum formula are ALL data entry. Which is why I am unable to understand where the 25 mil is coming from.

Genevieve P.

Hi @Gita Mooney

Thanks for clarifying. Are you referencing this sheet in other sheets?

The total count of cells referenced by formulas in a sheet cannot exceed 25 million. This includes cross-sheet references, in-sheet cell references, column references, and range references. However, only cells that contain formulas are counted towards the limit.

If this hasn't helped, please do connect with Support as you can then share your sheet and go through each individual column to identify where the references are hitting the limit.

Cheers,
Genevieve