Tracing Error - 1049 - Learn Excel from MrExcel Podcast
Hey, welcome back to the Mr. Excel netcast, I’m Bill Jelen. It’s basic, you start out with massive amount of data, say, how are we gonna analyze this? Well, let’s fire up activity table and see if we could solve this problem. Hey, welcome back to Mr. Excel netcast, I’m Bill Jelen, great tip today sent in by Emily. Emily says anytime that she has an error cell, we have this big formula down here that’s generating this error, and you’re not sure exactly where the error is coming from. I need to trace that through, I could go back to the formula’s tab and then use a evaluate formula. Now this was in Excel 2003, tools, formula editing, show formula editing tool bar and then the little magnifying glass is out there on the right hand side. What we can do now, is watch this calculated in slow motion, so you can individually hit, keep hitting evaluate, and eventually you’re gonna see that one of these references is going to change into an error, so, D14’s okay, that’s okay, E21, okay, that’s okay, that’s okay, that’s okay, okay, and, oh, finally that last thing, that summary C5 is where the DIV by zero error happens. So at least I know now which of those terms is the one that actually cause some problems. So, great tip, next time you have an error being generated, and it’s not just a simple little formula, it’s one or two references, use evaluate formula to go through and figure out exactly which reference is causing the error. Thanks for stopping by, see you next time for another netcast of Mr. Excel. Thanks for stopping by, see you next time for another netcast of Mr. Excel.