Quote:
Originally Posted by riothecat
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.
|
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.