Disable sheet reference check
In sheet €śCalculated€ť I have a formula referencing another sheet in the same
workbook: €śSrcData!$F$2:$F$20000€ť.
In order to refresh €śSrcData€ť the easiest is to remove and import from
elsewhere; the problem is that even if I disable formula auto-calculation,
the reference above becomes €śREF#!$F$2:$F$20000€ť.
Obviously, to avoid this problem, I can clear €śSrcData€ť and paste fresh
content rather that removing the sheet entirely.
Is there a way to diable refrence checking?
Thank you.
|