Get instant live expert help on I need help with trace precedents excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a keyboard shortcut to trace precedents
Solved by G. F. in 18 mins
where to find trace dependents and precedents, all those functions in the formula ribbon
Solved by O. J. in 16 mins
Hello. I'm having trouble with my spreadsheet - I am trying to replace my old spreadsheet to an updated version using the same contents but in a different order, but the new version comes up with the old terror "a formula refers to its own cell either directly or indirectly" etc. I have been through the show formula, Trace Precedents, Trace Dependents, Error checking, Evaluate formula, etc and both the original version and the second version are identical. Yet the original version doesn't indicate errors whereas the new version does and both are identical. I am now at the stage where my head hurts !!
Solved by C. L. in 17 mins
Would there be formulas to trace an entry in an excel file so that it can be find even when its position or content are changed? Thanks
Solved by V. A. in 22 mins
The cells in my spreadsheet aren't adding up, just showing the word VALUE. from there I cannot trace the error.
Solved by D. D. in 25 mins