View Single Post
  #1  
Old April 26th, 2004, 10:20 PM
Linda
external usenet poster
 
Posts: n/a
Default Circular reference error

Hi Guys,

Using Excel 2000. I have a workbook that is already saved. When I open the
workbook I get this error.


MS Excel cannot calculate a formula. There is a circular reference in an
open workbook, but the references that cause it cannot be listed for you.
Try editing the last formula you entered or removing it with the Undo
command.

Problem is, I don't know what I did last. There are about 8 sheets.

How do I figure out which formula is a circular reference? I don't even
know what that is, I am pretty much a beginner in excel. My formulas are
not really formulas, they are just really copying totals from one sheet and
adding showing the totals on another. There is a sheet that adds totals
from 2 sheets.

Thanks,
Linda