Forum Discussion
Formulas with external cell references not working`
Something has recently happened where I am unable to create formulas in one worksheet that reference cells in another worksheet unless I manually type the cell reference. If I try to create those fo...
What Excel version do you use?
If Excel 2010 or 2007, maybe you have opened 2 instances of the program. Or in other words: have you opened Excel twice? You cannot reference to cells in a worksheet that is opened in another instance.