Cross Sheet Reference - Error for more than 100000 references
We have a base sheet which contains around 9000 rows. We are generating some statistics and KPIs from that base sheet in another sheet.
There are total of 17 managed references in the KPI sheet where all computation is done. Somehow, we are now getting a warning message as below.
Also, the cells show as below.
Can someone please help and suggest, what could be the cause of this and how to fix this?
Note - The data will gradually increase over time. It is yearly data, so we could start from scratch as the year ends. All the managed references are active and needed. They do not repeat. I did verify that.
Help Article Resources
Check out the Formula Handbook template!