ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Circular (https://www.excelbanter.com/excel-worksheet-functions/209954-circular.html)

Christine[_3_]

Circular
 
my worksheet shows this message at the bottom. but I dont know where's the
error. what should i do?
thanks



John C[_2_]

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




Centrol

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






John C[_2_]

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








All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com