While referensing a cell in another worksheet in the same file with a
formula, some cells won't do it. Instead they just show the formula as typed
like "=Appl!C2". Why?