KBA-01110: Custom Macro Error when opening the BFA Workbook

Problem:

When I try to open the BFA workbook either from the Forecast document or from the Project Dashboard Options menu | Project Analysis selection, the following error message is displayed:

‘The custom macros in ../DashboardSpitfire.Forecast could not be initialized correctly.‘

Solution:

(You can still edit and save the document. Contact your administrator or the author of this document for further assistance.) Install the .NET Programmability Support for Microsoft Office Excel. You will need access to your Microsoft Office CD to add this component.

To add the Microsoft Excel .NET component:

  1. Select Control Panel | Add or Remove Programs.
  2. Select Microsoft Office 2003 and click Change.
  3. When Microsoft Office 2003 Setup opens, select Add or Remove Features and click Next.
  4. Select Choose advanced customization of applications and click Next.
  5. Click + to expose the Microsoft Office Excel components.
  6. Click on the drop-down to open the options menu for .NET Programmability Support and select Run from My Computer.
  7. Click Update.

Additional Comments:

When you install Microsoft Office, some components may not be installed but rather marked as Run from the CD or Install at First Use. The .NET components for Excel by default falls into the Install at First Use categories.


KBA-01110; Last updated: October 14, 2016 at 14:04 pm;
Keywords:  Add .NET