Some cells on the worksheet will show the information in the referenced cell.
Others only show the statement. For example, if I enter ='log'!K5, that's
exactly what appears in that cell, not the contents of the referenced cell.

John