Erroneous circular reference warnings in Excel 2008

External Since: May 04, 2008 Posts: 2

> Thank you for your report. We are working on a fix for the circular
> reference problem and hope to have an update with the fix out soon. It would
> still be very valuable to have your file to use as part of our verification
> of the fix. A file for the other problems you mention would also be very,
> very helpful. If you could send them to me at patmcmil.TakeThisOut@microsoft.com I would
> be very grateful.
>
> Thanks,
>
> Pat
>
>
> On 5/4/08 11:38 PM, in article ee8bff6.17.TakeThisOut@webcrossing.caR9absDaxw,
> "kanjanop@officeformac.com" wrote:
>
> > I have the same problem with Excel 2008 for Mac. There is no CIRCULAR when I
> > created it in MS Excel 2003. All formulas are correct as I retyped them for
> > Mac Excel (the reason I had to build a new one for Mac Excel was it couldn't
> > open by Mac Excel but NeoOffice could do it without any problem - Apple
> > salesperson and I tested NeoOffice and Mac Excel in Bangkok iStudio - I really
> > don't know why this problem occured). The CIRCULAR message is unreal as it
> > appeared and disappeared. For MS Excel, it will constantly show CIRCULAR all
> > the time if it is real circular. I'm willing to send my file to you (Mr. Bob
> > Greehblatt), if you want to take a look.
> >
> > Also, Mac Excel file has another problem as explained below. No problems at
> > all when I use MS Excel 2003.
> >
> > 1) If I change depreciation year for fixed asset #5 (i.e. from 5 years to 10
> > years), Mac Excel will not respond. I have to force quit.
> >
> > 2) If I include depreciation of fixed asset #4 and #5, Mac Excel will not
> > respond too.
> >
> > 3) I noticed that when I use "Trace Precedents" in Mac Excel, the Trace
> > Precedents reported wrong cell. Instead of pointing to the cell in another
> > sheet (this is correct), it points to cell in the same sheet too (this is
> > wrong as I don't have formula link from it). Please tell Mac Excel team about
> > this problem.
> >
> > As a result, I gave up using Mac Excel and use MS Excel right now.
>
> --
> Pat McMillan
> Macintosh Business Unit
> Microsoft Corp.
> This posting is provided �AS IS� with no warranties, and confers no rights.
>
>
> I just sent you the file

External Since: Feb 04, 2008 Posts: 5

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