Linked cells refer to source one row off.
 

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.

Linked cells refer to source one row off.
 

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.

Halwit wrote:

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

Linked cells refer to source one row off.
 

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" wrote:

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.

Halwit wrote:

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

Linked cells refer to source one row off.
 

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.



Halwit wrote:

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" wrote:

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.

Halwit wrote:

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


--

Dave Peterson