Circular

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

my worksheet shows this message at the bottom. but I dont know where's the
error. what should i do?
thanks
 
It means you have a circular reference that excel cannot evaluate properly.
If it just displays cirulcar, that means the reference is on a separate
sheet. Go through all your worksheets until you a worksheet that will say
Circular: A1 (for example). Then you will need to examine the formula to find
out why you are getting the circular reference.
 
Thanks John.


John C said:
It means you have a circular reference that excel cannot evaluate
properly.
If it just displays cirulcar, that means the reference is on a separate
sheet. Go through all your worksheets until you a worksheet that will say
Circular: A1 (for example). Then you will need to examine the formula to
find
out why you are getting the circular reference.
Click to expand...
 
If you have any questions about why you are getting the circular error (once
you found the specific cell), be sure to post back.
 
Back
Top