Erroneous circular reference warnings in Excel 2008

[kanjanop]

Thank you for your report. We are working on a fix for the circular

 

[frobozz]

I just downloaded and installed SP1 and my circular reference problem still exists.

I am still trying to pare down the sheet to something that exhibits the problem but does not contain all our proprietary stuff. The size of the workbook may in fact be part of the problem. It's not outrageous, but it is 16 sheets, some of which have over 300 rows and a few dozen columns.

Duncan

 

[Pat McMillan]

Thanks for these reports, Duncan.

Regarding the erroneous circular reference problem: We tried to get a fix
into SP1 but didn't quite make the deadline for that release. We are testing
a fix now and hope to release it as soon as possible. If you can provide me
with a file that reproduces the problem, I can add it to our testing matrix,
just to be sure. Please send to (e-mail address removed).

Regarding the bogus compatibility errors: Thanks for the report! I'll be
posting a bug for that and we will consider it for a future update.

Regarding the update issue with cell references: I'll look into that one and
post a bug if we don't already have one. I'll let you know if I need more
info, but it looks like you've done your homework already!

Thanks again,

Pat

 

[Pat McMillan]

Hi again, Duncan.

With regard to the problem of the linked cell not updating, it looks like I
am going to need more information from you, or some files to repro this.
Following your general steps, and using fairly small tab delimited data
sets, I don't see this problem. When I paste the data into a range on sheet2
that overlaps the cell linked to from sheet1, then the value of the cell on
sheet1 updates as expected. It could be that the problem you're seeing is
related to the size of the data being pasted, the size of the range you're
pasting into, the type of data in the source or destination range, or
something different. Is there any chance you could share an Excel file and
text file that reproduces this? If you can, please send it to me at
(e-mail address removed).

Thanks,

Pat

 

[JoelR]

Pat and Duncan, I too am having this same problem and have tried numerous
things to fix it with no success. I would be more than happy to send my
microsoft excel 2008 for mac worksheet to you, Duncan, if it would help solve
this problem.

Let me know and I will send it,

Joel

Hi again, Duncan.

With regard to the problem of the linked cell not updating, it looks like I
am going to need more information from you, or some files to repro this.
Following your general steps, and using fairly small tab delimited data
sets, I don't see this problem. When I paste the data into a range on sheet2
that overlaps the cell linked to from sheet1, then the value of the cell on
sheet1 updates as expected. It could be that the problem you're seeing is
related to the size of the data being pasted, the size of the range you're
pasting into, the type of data in the source or destination range, or
something different. Is there any chance you could share an Excel file and
text file that reproduces this? If you can, please send it to me at
(e-mail address removed).

Thanks,

Pat

On 5/14/08 9:56 AM, in article (e-mail address removed)9absDaxw,

I just downloaded and installed SP1 and my circular reference problem still
exists.

[quoted text clipped - 5 lines]

Duncan

 

[Pat McMillan]

Thanks Joel. Can you tell me which problem you're referring to? The
erroneous circular reference problem or the issue of certain linked cells
not updating when pasting data over the source range?

If it's the erroneous circular reference issue, we don't need any more files
for that. We have a fix ready that we hope we will be able to release soon
to solve the problem.

Thanks,

Pat

Pat and Duncan, I too am having this same problem and have tried numerous
things to fix it with no success. I would be more than happy to send my
microsoft excel 2008 for mac worksheet to you, Duncan, if it would help solve
this problem.

Let me know and I will send it,

Joel

Hi again, Duncan.

With regard to the problem of the linked cell not updating, it looks like I
am going to need more information from you, or some files to repro this.
Following your general steps, and using fairly small tab delimited data
sets, I don't see this problem. When I paste the data into a range on sheet2
that overlaps the cell linked to from sheet1, then the value of the cell on
sheet1 updates as expected. It could be that the problem you're seeing is
related to the size of the data being pasted, the size of the range you're
pasting into, the type of data in the source or destination range, or
something different. Is there any chance you could share an Excel file and
text file that reproduces this? If you can, please send it to me at
(e-mail address removed).

Thanks,

Pat

On 5/14/08 9:56 AM, in article (e-mail address removed)9absDaxw,

I just downloaded and installed SP1 and my circular reference problem still
exists.

[quoted text clipped - 5 lines]

Duncan

 

[JoelR via MacKB.com]

Pat, it is the erroneous circular reference issue so I guess I'll just wait
for the fix. Thanks a lot,

Joel

Thanks Joel. Can you tell me which problem you're referring to? The
erroneous circular reference problem or the issue of certain linked cells
not updating when pasting data over the source range?

If it's the erroneous circular reference issue, we don't need any more files
for that. We have a fix ready that we hope we will be able to release soon
to solve the problem.

Thanks,

Pat

Pat and Duncan, I too am having this same problem and have tried numerous
things to fix it with no success. I would be more than happy to send my

[quoted text clipped - 30 lines]