CODEWITHSUNDEEP
excelexcel-formulacircular-reference
Operations
Operations

Reputation: 21

How to Silence Excel Circular Reference That Will Never Occur?

=IF(AND(CELL("row")=ROW(), CELL("col")<>COLUMN()), NOW(), [@Updated])

I have a column for the time the row was updated using this formula. It works perfectly. [@Updated] references its own cell so that it doesn't change when other rows are updated. Excel thinks it is a circular reference and gives the annoying prompt every time you open the worksheet. This formula cannot be circular by design.

I cannot expect everyone in my company to enable iterative calculations in Excel, so that is not a solution. I cannot use VBA instead of this formula because that clears the undo history.

Any ideas?

Upvotes: 0

Views: 64

Answers (0)

Related Questions