“Robust and Dynamic”

Excel workbooks produced by Excel Expert  are “Robust” and “Dynamic”.  But what does this mean?

A “Robust” workbook keeps working no matter what happens.  Its immune to errors introduced by bad data in a table, a misspelled entry, or missing data value.


A “Dynamic” workbook adapts to ever-growing amounts of data, and all the equations keep working.  There is never a need to edit equations because a data table has exceed some limits.  Adding new items to dropdown lists is easy, just visit a ‘Lists” page and add the new salesman, part number, account name, or other such item to the proper list.  All the dropdowns using that list will automatically see the new items!