Sounds like the new cells are formatted as Text.

Re-format to General then F2ENTER on your formula cell(s)


Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 13:14:02 -0700, Curtis
wrote:

when I try to link cells on different sheets from the same workbook it doesnt
seem to work properly. In the new cell which i want to display info from
another work sheet so I type:

='AB-Info'!B50

And the formula stays in my new cell. When it should be the words from the
original cell.

Any tips?

Thanks