• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Tracing Excel Formula, Names, over multiple worksheet

M

Murali Nair

New Member
I have an estimation file, which contains 18 Worksheet, 17 Worksheet are full of formule, Names and calculation, and 1 Worksheet contains the Master in which the actual estimation is done, all cells are linked to the 17 Worksheet, for getting the value when anyone does the estimations in the First Master Worksheet.

This file was made by my previous collegues who has left our concern, now i need to do some additions , but first as i require to understand the formulae and caln, is there any way in excel whcih will help to trace the formulae, otherwise i have to manual go to each cell and and then search for the formulae, and then jump to the next.

ITs a long tedious work.


Hope u understood what i have written.

I am unable to attach the file as its v. confedential and i cant break it and attach it also as it will loose all the links

Thanks.
 
Hi,


Select Formulas tab then select evaluate formula under formula auditing menu, then

select evaluate. Now it will show the value and how it is working.

(To view the formula for entire sheet press Control+~ to retain again press Control+~)


Thanks,

Suresh Kumar S
 
I'd recommend reading Debra's latest article here:

http://blog.contextures.com/archives/2012/09/27/list-all-formulas-in-workbook/


Specifically written for understanding an inherited, complicated workbook and shows some tricks for seeing all the formulas and understanding how they work.


Also, under the Formula Ribbon, in formula Auditing controls, there are tools to help you draw literal arrows tracing dependents/precedents for cells.
 
Thanks for all your help, v.much, but all this options only cover 1 Worksheet, this formula has links to nearly 17 worksheet. for eg.

Master WorkSheet has a value which comes from a Name formula in Worksheet 3, 7, 12, 15, 16, like this it covers across 17 worksheet.


What i mean to say a roadmap showing links from the Master worksheet to all the formula linked to that field.
 
You must log in or register to reply here.
Back
Top