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.