I am getting Cross-Sheet formula issue which is limited to Maximum Allowed (100000)
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.