Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular
my worksheet shows this message at the bottom. but I dont know where's the
error. what should i do? thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular
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. -- ** John C ** "Christine" wrote: my worksheet shows this message at the bottom. but I dont know where's the error. what should i do? thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular
Thanks John.
"John C" <johnc@stateofdenial wrote in message ... 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. -- ** John C ** "Christine" wrote: my worksheet shows this message at the bottom. but I dont know where's the error. what should i do? thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular
If you have any questions about why you are getting the circular error (once
you found the specific cell), be sure to post back. -- ** John C ** "Centrol" wrote: Thanks John. "John C" <johnc@stateofdenial wrote in message ... 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. -- ** John C ** "Christine" wrote: my worksheet shows this message at the bottom. but I dont know where's the error. what should i do? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular | Excel Worksheet Functions | |||
Need help with Circular (?) | Excel Worksheet Functions | |||
Circular Ref. | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Worksheet Functions | |||
Circular:G4? | Excel Worksheet Functions |