I only have a basic knowledge on excel, pivot tables are about as advanced as
I get, and I have a question that might not even have an answer. I am working
in finance and my boss gave me a very large excel workbook with tons and tons
of tabs and thousands of lines and it is basically a calculator that prices
out corporate projects and predicts the return and things like that. It spits
out all kinds of data and my boss thinks that something is wrong with the
numbers it is calculating for distribution costs. SO...he wants me to figure out
what excel is taking into account when calculating this distribution cost number, so that he can
see if it is using the wrong terms to get this end value. The reference is
all intertwined through various tabs and goes on and on so I am wondering if
there is an easy way to just see the total trail or path that excel is using
to derive this end number? I know how to find the dependents and precedents
and things like that, but once it takes me there...there are a ton of other
reference that make up that reference. Is there a way to display how this
value is calculated from beginning to end without looking into every single
reference? I am using Excel 2007 by the way! Thanks!