Excel - This workbook has lost its VBA project

When opening a Projector report you may receive the following warning message - This workbook has lost its VBA project, ActiveX controls and any other programmability related features.

This occurs when a required component of Microsoft Office is not installed on your system.

Solution

To fix:

  1. Go to Programs and Features in your control panel
  2. Choose to change your Microsoft Office installation.
  3. Choose to add/remove features
  4. Under Office Shared Features, make sure that Visual Basic for Applications is installed