You have a large formula which is generating an error. To find which reference in the formula is causing the problem, use the Evaluate Formula tool to step through the formula. Episode 1049 will show you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Basically, we start out with massive amount of data.
How we're gonna analyze this. Let's fire up a pivot table.
Let's see, if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Great tip today sent in by Emily.
Emily says anytime she has an error so, so, we have this big formula down here, that's generating this error, and you're not sure exactly where the error is coming from. If you need to trace that through, If we go back to the Formulas tab and then use Evaluate Formula, now this was in excel 2003.
Tools, Formula Editing, Show Formula Editing Toolbar and then the little magnifying glass was out there on the right-hand side.
What we can do now is watch this kit calculated, in slow motion.
So, you can individually hit, keep hitting evaluate and eventually you're going to see that one of these references is going to change into an error.
So, T for teams Ok, that's Ok, E21 Ok, That's Ok, That's Ok, that's Ok and Oh, finaly the last thing that summary C5, is where the DIV/0, error happens.
So, at least I know now, which of those terms is the one that's actually causing the problem.
So, great tip next time you have an error being generated, and it's not just a simple little formula one or two references, use Evaluate Formulas, that go through and figure out exactly, which reference was causing the error.
Thanks for stopping by.
See you next time for another netcast from MrExcel Thanks for stopping by.
See you next time for another netcast from MrExcel.
I'm Bill Jelen.
Basically, we start out with massive amount of data.
How we're gonna analyze this. Let's fire up a pivot table.
Let's see, if you can solve this problem.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
Great tip today sent in by Emily.
Emily says anytime she has an error so, so, we have this big formula down here, that's generating this error, and you're not sure exactly where the error is coming from. If you need to trace that through, If we go back to the Formulas tab and then use Evaluate Formula, now this was in excel 2003.
Tools, Formula Editing, Show Formula Editing Toolbar and then the little magnifying glass was out there on the right-hand side.
What we can do now is watch this kit calculated, in slow motion.
So, you can individually hit, keep hitting evaluate and eventually you're going to see that one of these references is going to change into an error.
So, T for teams Ok, that's Ok, E21 Ok, That's Ok, That's Ok, that's Ok and Oh, finaly the last thing that summary C5, is where the DIV/0, error happens.
So, at least I know now, which of those terms is the one that's actually causing the problem.
So, great tip next time you have an error being generated, and it's not just a simple little formula one or two references, use Evaluate Formulas, that go through and figure out exactly, which reference was causing the error.
Thanks for stopping by.
See you next time for another netcast from MrExcel Thanks for stopping by.
See you next time for another netcast from MrExcel.
