For the sake of clarity it is always best to post actual cell references and
formulas.

Locations like "above", "beside", "below" makes it hard to troubleshoot.

e.g. in A10 you have =Sheet2!C10

The contents of Sheet2 C10 show up in A9 but not in A10

Do you have a formula in A9?


Gord Dibben MS Excel MVP

On Thu, 25 Sep 2008 09:02:01 -0700, TOS
wrote:

Thanks Gord, I've tried that, I can't figure it out, every other worksheet
has the same link and it works for them, this particular one, once I enter
the data in the worksheet, I go to the master sheet and it has the correct
data except it is in the cell directly above...it is the strangest thing...