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!