Error Message "Some cross-sheet formula can’t be updated"

Ibrahim Khaleel

Dear Smart Team,

I am getting below error message again which cause not triggering workflow automatically.

"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 get the permanent solution to avoid this error.

Refer attached images about Reference Managers and Error Message

Thanks for prompt support and appreciate in advance.

Best regards.

Paul Newcome

You are going to need to cut down on how many cells you are referencing. Maybe revisit some formulas to see if any can be made more efficient (INDEX/MATCH instead of VLOOKUP), see if there is some way to consolidate data on the source sheet(s) before referencing it.

Ibrahim Khaleel

Dear Paul,

Finally I replaced all vlookup formula with Index/Match formula since i have mapped data with multiple sheets and now issue is permanently resolved.

Thanks for your prompt support.

Best regards,

Paul Newcome

Happy to help. 👍️

Ibrahim Khaleel

Refer Attached Image

Ibrahim Khaleel

Refer the References Managers list

Paul Newcome

You are going to need to cut down on how many cells you are referencing. Maybe revisit some formulas to see if any can be made more efficient (INDEX/MATCH instead of VLOOKUP), see if there is some way to consolidate data on the source sheet(s) before referencing it.

Ibrahim Khaleel

Dear Paul,

Finally I replaced all vlookup formula with Index/Match formula since i have mapped data with multiple sheets and now issue is permanently resolved.

Thanks for your prompt support.

Best regards,

Ibrahim Khaleel

Paul Newcome

Happy to help. 👍️