I have a spreadsheet that when I open it, I have to update the sheet or not. I hit the button (either one) and it says I have a circular reference error. I have gone over the whole book and cannot find it. I used the error checking tool and nothing. What else is there top do:

Hi
usually the circular reference is indicated in the lower left corner of the sheet

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you. I couldn't find the circular reference, even through error check. Everything else but no circular references. sTill have the error but deleted all but one sheet and it is still there

Best to post the workbook if not confidential...so we can help investigate...

Unfortunately I cannot post, privileged work product. It's just an annoyance, I'll try to redo it and leave out product and work info.

Thank you all
stand by for another, hopefully easier post

Is this the same file that has "an amount error after the calculations", per your posting at https://www.msofficeforums.com/excel...e-amounts.html ?

I was suggesting that the latter is due to rounding issues.

But circular references, be they on purpose or by accident, can cause all sorts of unexpected results.

Are you using the Circular References tool in the Error Checking dropdown? It should identify both the cell location and sheet where the circular reference is (see attachments)

Attached Images

	circular reference 1.png (69.8 KB, 16 views)
	circular reference 2.png (78.9 KB, 16 views)