Diagnosis
Errors occurred while upgrading the 3.x Analyzer APIs. The APIs were notupgraded successfully.
When 3.x APIs are upgraded, the VBA code called from the 3.x Analyzerexit SAPBEXonRefresh(queryID As String, resultArea As Range) is adjustedso that the 3.x Analyzer APIs are compatible with the 7.0 Analyzer. Insome cases, the 3.x APIs are not supported but dummy wrapper functionsreplace those functions so that the VBA code in the workbook does notresult in runtime errors.

System Response
The Analyzer is unable to upgrade all the APIs in the VBA code for theworkbook. Without sufficient error handling, this may cause compile timeerrors when the custom APIs are run in the workbook.

Procedure
The most probable reason is that access to the VBA project is denied.This can be corrected as follows:
In Microsoft Excel, choose Tools --> Macros -->
Security.
On the Trusted Publishers tab page, select Trust access toVisual Basic Project to allow access to the Visual Basic project. Ifyou are not authorized to do this, contact your system administrator.
Another possible reason is incorrect use of APIs. We recommend checkingwhether it is possible to refresh the workbook and run the VBA code inthe 3.x Analyzer successfully. If this is not possible, APIs are notbeing used correctly.
If the problem persists, you may need to manually check and correct howthe APIs are used in the VBA code.