ranuse
01-19-2011, 06:37 AM
Hi,
I'm having problems with referencing. For example, cell A1 in "Sheet1" contains the formula ='Sheet2'!B1 of current workbook. When I delete the column B in Sheet2, A1 will give me a reference error ='Sheet2'!#REF!.
How can I get the formula to update and accept the new values at B1 rather than the old?
I'm having problems with referencing. For example, cell A1 in "Sheet1" contains the formula ='Sheet2'!B1 of current workbook. When I delete the column B in Sheet2, A1 will give me a reference error ='Sheet2'!#REF!.
How can I get the formula to update and accept the new values at B1 rather than the old?