![]() |
Circular
my worksheet shows this message at the bottom. but I dont know where's the
error. what should i do? thanks |
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 |
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 |
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