Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable/ignore compatibility check during SaveAs | Excel Worksheet Functions | |||
Check-box relative reference | Excel Discussion (Misc queries) | |||
HowTo disable cell reference update | Charts and Charting in Excel | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Check Box reference name | Excel Discussion (Misc queries) |