[f292]

What we have found is that one of the biggest problems in the BI space is the fact people are not able to code and resort to some of the horrific formulae we see. But agreed - including macros would add a huge new layer of complexity!

[rahimnathwani]

I much prefer reading Excel spreadsheet with complex formulae, than those with complex macros. It's much easier to follow things around and literally 'see' what's going on.

Parentheses FTW!

[robzyb]

Absolutely!

Also, the people who write macros are invariably not programmers[1], and the macro code they write is... not so great.

[1] I am a programmer who writes macros, and presumably there are others too.