I have 5 separate workbooks where the trace precedents works, but
trace dependents doesn't. All the happens is I get a dialogue box
saying that 'The Trace Dependents command found no formulas that refer
to the active cell' when clearly there are.

Obviously, there is something in common with all of them which is
preventing it from working. What concerns me is that the sheets are
somehow corrupt and are not calculating properly - which is going to
be a problem as the sheets are financial and need to be signed off by
an external auditor!

I have found threads suggesting other users have had this problem as
well, but have not come across any posts that have given any concrete
solutions or steers to a solution. Any ideas or areas I can look at in
order to try and rectifiy this?

Many thanks,

Tom.