How Do I Resolve Errors From the Service?

If you attempt an operation with the Excel add-in but the service returns an error, review the resolution steps for the error code.

Refer to HTTP response status codes for more information.

Error Cause Resolution Steps
(401) Unauthorized The service does not accept the credentials provided.
  • Verify your credentials.
  • Use the Network Monitor to determine which service was being accessed.
  • Verify the authentication type.
(403) Forbidden The current user is not allowed to perform the requested operation.
  • Use the Network Monitor to determine the specific service and operation.
  • Save the network monitor report.
  • Consult the team that provides that service to determine what roles and permissions are required (and how to configure them).
(400) Bad Request Multiple causes
  • Use the Network Monitor to determine the specific service and operation.
  • Save the network monitor report.
  • File a service request with the team that provides the REST service and attach the report.

    Ask them to determine why the service rejected that specific request.

The add-in supports a variety of options that can accommodate diverse service requirements. Once you know why the service rejected the request, you can explore whether there is an option to solve the issue.

For example, if a particular service does not support parallel requests, then disable parallel requests.

Note:

In some cases, the REST service may not be compatible with the add-in's current capabilities. This would need to be confirmed by the REST service and the Excel add-in teams.

(500) Internal Server Error

May also appear as: The operation failed due to an internal server error. Contact the system administrator to review the server logs to determine the actual cause. (VBAFE-00109)

 
  • Use the Network Monitor to determine the specific service and operation.
  • Save the network monitor report.
  • File a service request with the team that provides the REST service and attach the report.

    Ask that team to investigate the cause of the internal server error.

(404) Not Found This generally happens with a bad URL.
  • Use the Network Monitor to determine the specific service and operation.
  • Save the network monitor report.
  • File a service request with the team that provides the REST service and attach the report.
  • Adjust the workbook configuration as needed.

Note:

Some customers have run into (404) Not Found errors when using the FA login host instead of the regular host.

The FA REST services are not available from the login hosts. If you spot the word "login" in the host name, try the host from the FA welcome page instead.