To prevent Excel from disabling an add-in, you should use Excel add-ins from trusted sources only. Once you do this, this ensures that Excel recognizes the add-in as safe and avoids any disruptions.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.