I am trying to point a cell to another cell on a different sheet in a
workbook. Instead of displaying the target data, it is displaying the
formula. I have never had this happen before. EX: (='Shift Analysis'!C5)