Hi,

I am having this problem. I have an advanced excel formula on SHEET2 that is referencing SHEET1.

If I change out data on SHEET1, every field in SHEET2 shows #REF!.

Is there a way I can lock down the formula on SHEET2, or create a work around to avoid #REF! when replacing data on SHEET1?

Thanks,
Arba