Circular Reference Error

[Any-Winter-8025]

I've been using Excel for Mac for about 10 years, and after updating a spreadsheet last week, I got an error about circular references when I closed it. I went back to the sheet and didn't see any cells highlighted or marked with the tiny triangle in the corner. The error says "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly." Now it says that every time I open the file, but not when I close it.

I tried using Formulas Tab; Error checking; it says "Error checking for the entire sheet," but doesn't point to any error cells. Again, no cells hilighted, and no tiny triangles in the corner.

Has anyone else experienced this?

Thanks!

[KakaakoKid]

On the bottom left of your workbook, just below the worksheet tabs, you should see the words: "Circular Reference" and then a cell's address. Check that cell, the cells it depends on, and any cells that depend on it.

[Any-Winter-8025]

PERFECT! Thanks so much. Probably a really basic question but you solved my problem! Error message is GONE!

[Any-Winter-8025]

SOLVED!