WHY DO I RECEIVE THE ERROR MESSAGE “THIS WORKBOOK HAS LOST ITS VBA PROJECT, ACTIVEX CONTROLS AND ANY OTHER PROGRAMMABILITY-RELATED FEATURES” WHEN I OPEN EXCEL AFTER INSTALLING OFFICE CONNECTOR?

 

Resolution

To solve this you need to change your installation of Microsoft Office.

1. Close all Microsoft Applications.
2. In the Control Panel double click Add or Remove Programs or Programs and Features with Windows Vista and Windows 7.
3. Select Microsoft Office in the list and click on Change.
4. Select Add or Remove Features and then click Next.
5. Under Options, expand the Office Shared Features list, select Visual Basic for Applications and set it to Run from My Computer.
6. Click Continue to install the Visual Basic for Applications feature.

After the installation, your Office Connector software will be able to function in Excel.