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...