Change Linking Source

  • Thread starter Thread starter TOS
  • Start date Start date
T

TOS

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??
 
Place the linking formula in the correct cell on the Master sheet?


Gord Dibben MS Excel MVP
 
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...
 
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
 
Back
Top