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.

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

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

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