Calculate/Circular Reference Problem

[Matt]

I'm using Excel 97and I have a worksheet with many large matrices and
a few user defined functions. When I open the worksheet, I get a
circular refence message saying" Excel cannot calculate a formula.
The circular reference is in an open workbook, but the refernces that
cause it cannot be listed for you..." After looking at all the open
worksheets no cell was identified that was causing the problem. So, I
then proceed to recalculate the sheet with <crtl><alt><f9>, that seems
to solve the problem, because, "circular" dissappeared from the status
bar and everything seems to be normal. Now excel is locking up when I
try to make one cell equal to another, but It had worked previously.
If anyone has any help, that wuld be greatly appreciated

 

[Stephen Bullen]

Hi Matt,

I'm using Excel 97and I have a worksheet with many large matrices and
a few user defined functions. When I open the worksheet, I get a
circular refence message saying" Excel cannot calculate a formula.
The circular reference is in an open workbook, but the refernces that
cause it cannot be listed for you..." After looking at all the open
worksheets no cell was identified that was causing the problem. So, I
then proceed to recalculate the sheet with <crtl><alt><f9>, that seems
to solve the problem, because, "circular" dissappeared from the status
bar and everything seems to be normal. Now excel is locking up when I
try to make one cell equal to another, but It had worked previously.
If anyone has any help, that wuld be greatly appreciated

If this workbook isn't supposed to have any circular references, you
might like to try finding them using the findcirc utility on my web
site.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

 

[Matt]

Thanks Steven,
I didn't have any circular references, but I did solve the problem
by updating to the sr-1 and sr-2b office updates.

Matt