Thursday, 7 July 2011

little issue with Excel sorting

I was going nuts trying to sort a little table in Excel which was created using some formulas... Excel was just sorting based on the formula in the cell rather than the cell value.... after googling a lot, I found out that in Excel 2007 the "Calculation" default option is set to "Automatic".... To avoid my problem, I just needed to turn if OFF and switch it to Manual. The option is in "Formulas" tab in Excel 2007, the right most choice "Calculation Options."

Found the answer on a Excel discussion board.