Circular Reference Won't Go Away
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?