Tracing Precedents and Dependents - BEEP vs. Error

[Guest]

Hi,

In an older version of Excel I used to be able to click on a cell that DIDN'T have any precedents or dependents, and select the TRACE button, and simply hear a BEEP. I liked that -- I could move right on to the next cell and check again.

Now, for some reason, when I select the tool when there is no precedent or dependent, then I get an Error Dialog Box telling me there are none -- and I have to click OK for the box to go away.

I go through literally hundered of cells checking dependents and precedents on some projects, and this is a MAJOR inconvenience. I suspect there is an easy way to fix this, but it has eluded me. Any advice?

Thanks!
Ian

 

[Guest]

.. . . BUMP . . .

Anyone have any idea how to disable the error dialog box from popping up when selecting Trace Dependents or Trace Precedent tools in a cell that has no Dependents/Precedents?

Thanks!
Ian