maybe the strategy in those cases is to augment the core spreadsheet with tools that can unit test it and broadcast changes etc