Problem:
The following error may be encountered when opening an SOV, BFA or Period Distribution workbook in Microsoft Excel:
Programmatic access to the Microsoft Office Visual Basic for Applications project system could not be enabled
or
The customization assembly could not be found…
Unfortunately, this error is often reported as
Microsoft.VisualStudio.Tools.Applications.Runtime.ControlNotFoundException: This document might not function as expected because the following control is missing:
The dialog with the above message has a Details button, and the actual error is in the details for example:
This document might not function as expected because the following control is missing: Sheet8
Solution:
To resolve this problem:
Please follow the “procedure” outlined in KBA-01519
KBA-01496; Last updated: January 24, 2018 at 15:05 pm
Keywords: PD, Budget