Its sounds like you may have some rogue spaces in either the sheet name or
the formula.

In the formula cell enter = then navigate to johnsmith A20 and see if that
works.

Mike

"Gatsby" wrote:

If I enter =Sheet2!A20 into a cell in another sheet the value appears. Great!
If I enter =JohnSmith!A20 it doesnt work. Why? It asks for the location of
John Smith even though his sheet is in same workbook.
Thanks

Gatsby (Not the Great)