View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amy Ryan Amy Ryan is offline
external usenet poster
 
Posts: 2
Default How do I solve circular references?

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.