Linked cells refer to source one row off.

[Guest]

I have several spreadsheets which share data among them. Frequently, the
"link to" spreadsheet cell indicates an address which is one row off, ie;
the source date is in F24 but the formula reads F23. This results in the
wrong data, of course. Seems to affect 2 items only... the rest are OK. I
have not inserted rows in the source file. Running EXCEL 2000 under XP.

 

[Dave Peterson]

The only time I've seen this is when I've inserted rows into the "sending"
workbook's worksheet--with the receiving workbook closed.

Not to be to offensive, but I bet someone inserted a row when you weren't
looking--or the original formula was hosed when it was written.

 

[Guest]

Thanks for your response. No, nobody else has access. I wonder if part of
the problem has to do with the fact that I download all my "personal" files
at home and massage them at work vice versa? I just check the problem at
work and it's OK.

 

[Dave Peterson]

When I see errors like this (even with workbooks I edit), I blame the user. If
you're anything like me, I bet you do lots of editing and don't know when
everything was done--well, I know I can't keep track.