It's not just Excel, it's BI in general.

Does BI development go through the same rigour that application development has to? I seriously doubt it!

Excel is particularly prone because its greatest strength is its greatest weakness.