I've inherited an Excel file at work that every time you load up gets hit with a popup message warning of a malfunctioning formula due to a circular formula problem.
I understand what the problem is, but I can't get rid of the message. It doesn't help that I can't find where the circular problem is. I think the cell in question may have been deleted at some point in the past, yet the message keeps popping up.
Is there some way to permanently get rid of this message (for this file) or at least locate the source cell of the problem?
I understand what the problem is, but I can't get rid of the message. It doesn't help that I can't find where the circular problem is. I think the cell in question may have been deleted at some point in the past, yet the message keeps popping up.
Is there some way to permanently get rid of this message (for this file) or at least locate the source cell of the problem?