Apption Blog Working with Huge Excel models

We have been approached by a large organization whose Excel modelling is a little out of control. Like lots of companies, in their early days, they plugged a few formulas into an Excel worksheet to manage their widgets and all went well. As their business increased, more formulae were added and tweaked and the model grew. Soon it was time to expand onto new worksheets so they can tab around and reduce clutter. Today they have hundreds of Excel workbooks with references between them. Ouch. Now it's a maintenance nightmare.