I am getting Cross-Sheet formula issue which is limited to Maximum Allowed (100000)

Dear All,

I am getting below error message.

"Some cross-sheet formula can’t be updated, because this sheet has more cell referenced from other sheets than the maximum allowed (100000)"

How can I fixed the above issue since I am maintaining history table and all completed records I am taking from historical table using Vlookup formula.

Need your suggestion and support.

Thanks and best regards.


Best Answers