Formula Auditing Functionality Not Working

[ActuallyActuary]

Hi

I have a fairly large (33Mb) and complex workbook which has stopped allowing me to trace dependents on some formulas. Trace precendents is still working however.

Note that this isn't that the functionality is 'dimmed', it is that the application states that there are no dependents when it is possible to find dependents.

Is this a bug, and if so can it be fixed? I've searched for this problem and haven't so far found any co-sufferers!

 

[Derek Brown]

Hello and welcome to The Board.
You did not say which version of Excel is being used, not that it would make any difference to my suggestion.
The first thing that I would try would be, using a COPY of the workbok, open & repair it to see if that makes a difference.
To do this, start Excel and open the COPY of the workbook using File | Open and Repair (this is an option on the drop-down arrow on the 'Open' button).