Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Arran
 
Posts: n/a
Default Circular warning not showing up

I used to get an error message at the bottom of my excel window that read
'Circular' and would list a cell that was involved in the circular. Now, in
the place where that error used to show up, there is 'Ready
Calculate' and no error, even though there is a circular reference. Is there
a way to make the error show up?
  #2   Report Post  
Ken Wright
 
Posts: n/a
Default

You likely have Tools / Options / Iterations checked, which will allow circs
to calculate through a number of iterations. An example of this would be
when some forms price contracts they may have a particular overhead that is
a % of the sell price, yet is itself a part of that sell price. Just untick
it, but be sure you were meant to.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Arran" wrote in message
...
I used to get an error message at the bottom of my excel window that read
'Circular' and would list a cell that was involved in the circular. Now,

in
the place where that error used to show up, there is 'Ready
Calculate' and no error, even though there is a circular reference. Is

there
a way to make the error show up?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highest Value / Circular Reference Help Josh M Excel Discussion (Misc queries) 1 May 23rd 05 07:33 PM
Highest Value / Circular Reference Help Josh M Excel Worksheet Functions 0 May 23rd 05 06:49 PM
formula in cell not showing result Leolin Excel Worksheet Functions 8 March 18th 05 05:36 PM
Help solve a Circular Reference brupub Excel Worksheet Functions 6 February 14th 05 07:11 AM
Bar showing value for missing data smboyd Charts and Charting in Excel 1 February 1st 05 09:53 PM


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"