Circular?

S

Shhhh

Hello All,

On the bottom of my excel window, in the bottom left corner it says ready
(it has always said that), on the bottom right corner, what is printed
varies "num", "Ovr", etc... I know what all these designations mean...

however today I noticed on the left side under the tab for sheet3 it says
circular... what does this mean? it appears on all my open workbooks.


Thanks,
Shhhh
 
C

Chip Pearson

It means that you have a circular reference, which is a formula
that directly or indirectly refers to itself.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
S

Shhhh

Thanks Chip... how do I fix this? or at least how do I go about finding it?

Thanks,
Shhhh
 
C

Chip Pearson

Next to the word 'Circular' in the status bar is the cell which
contains the circular reference. Change the formula in that cell
so that it doesn't refer to itself. Post the formula here if you
need help.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top