Circular Reference Won't Go Away

eceisin

Hi,

 

I'm working on fairly large sheets that reference many other sheets.  My main summary sheet is doing SUMIFS formulas to summarize and sum to a higher level.  The summary sheet column is showing a Circular Reference error.  I found the error on my raw sheet and corrected.  However the main summary file still shows a circular reference error that won't go away even after re-doing the reference and formula.  Again, the sheet it is referencing does not show an error in the column I am summing. Any advice?

Thanks,

Liz

Mike Wilday

Could you provide a screenshot for us to see what is going on while hiding any sensitive information?