Better trace precedents

[excel4]

I use trace precedents a fair bit to find errors but I just find it's not quite up to the job. It doesn't work across spreadsheets or with lookup formulas (it doesn't point to the cell thats actually looked up). Are there any better plugins out there? Does anyone else find this a problem or are there ways around this?

 

[kisauni]

Re: Great tool for understanding and fixing spreadsheets

Hi

I just registered with the forum so that I can thank you for producing and distributing this amazing tool.

Really made my day trying to find how to easily trace through formulas after struggling with the built in trace precedents tool.

Joel

Hi, you could also try my old tool:

http://www.mrexcel.com/forum/genera...r-questions/338332-trace-precedents-tool.html

The download link in the original post appears dead, but you can use Drill or I can send it to you.