Tag Archives: error

Reinhart & Rogoff: The Austerity spreadsheet error

We’ve discussed this on the yahoogroup of the European Spreadsheet Risk Interest Group, of which I’m the current chair. Here’s my summary of The Spreadsheet Error Heard Round the World, with my commentary followed by the background. 1) The authors … Continue reading

Posted in Excel/VBA, Research, Risk, Software Testing, Uncategorized | Tagged , , , | Leave a comment

Chart defined name oddity

I’ve seen this before but can’t remember where. It was discussed on the Excel-L list starting 15 Oct 2012 with the subject line “charting challenge: cannot change title’s (formula) reference to a worksheet cell” Try this in Excel 2010: in … Continue reading

Posted in Excel/VBA | Tagged , , , , , , | Leave a comment

Free Excel formula highlighting tool

My main product is the XLTest addin that does a comprehensive shakedown of Excel workbooks. I’ve picked out the most popular feature, colour coding cells by formula region, and give it away as a free taster, the XLTest Colorizer. It … Continue reading

Posted in Excel/VBA, Risk | Tagged , , , , , , , , , , , , , | Leave a comment