If you have trouble finding the circular reference, maybe Stephen Bullen's
utility will help:

http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip

Amy Ryan wrote:

I have a circular reference in a sheet and when i want to link cells to
different sheets, the value is coming up as zero. I do not want to copy and
paste the values because if i make a change on the sheet i want it to be
reflected on the subsequent formulae.

--

Dave Peterson