Last week I covered the definition of the circular reference error, and what it looks like in various spreadsheet programs. This week I’ll cover how to track down the source of the problem, and discuss some common causes/solutions.

I mentioned earlier that one very common error code in spreadsheets is the “circular reference”. There’s a lot to discuss about circular references, so in this post I’ll cover the definition of the error and what it looks like in… Read moreSpecific errors: Circular references (part 1)

I mentioned earlier that one very common error code in spreadsheets is what I’ll call the “name error”. In this post I’ll cover the definition of the error, what it looks like in various spreadsheet programs, and some simple techniques… Read moreSpecific errors: Names

Once you start working with functions and names and basically anything other than flat values, there’s a chance you’ll wind up with some sort of error messages. There are a number of different errors you might run into, but most… Read moreCommon errors