Change Linking Source
 

I have a spreadsheet with numerous linked worksheets- in only one of the
worksheets, once I enter the data it updates it to my master document but it
moves it up one cell, can someone help??
--
thank you

TOS

Change Linking Source
 

Place the linking formula in the correct cell on the Master sheet?


Gord Dibben MS Excel MVP

On Thu, 25 Sep 2008 06:10:01 -0700, TOS
wrote:

I have a spreadsheet with numerous linked worksheets- in only one of the
worksheets, once I enter the data it updates it to my master document but it
moves it up one cell, can someone help??

Change Linking Source
 

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...
--
thank you

TOS


"Gord Dibben" wrote:

Place the linking formula in the correct cell on the Master sheet?


Gord Dibben MS Excel MVP

On Thu, 25 Sep 2008 06:10:01 -0700, TOS
wrote:

I have a spreadsheet with numerous linked worksheets- in only one of the
worksheets, once I enter the data it updates it to my master document but it
moves it up one cell, can someone help??

Change Linking Source
 

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...