Excel report- hidden compiler error in 2016 800xa 6.0.3 and OS server 2012 r2

Hi,

I am facing a problem of excel report add in error.

Whenever I am adding the Add-in from the excel options, I am getting the below mentioned error.

Microsoft forms - could not load some objects because they are not available on this machine

When I click on OK button data direct addin got added.

But whenever I am clicking on the history values button I am getting the above mentioned error message and after pressing OK onto it I am receiving one more message as below mentioned.

Microsoft visual basic applications - compile error in hidden module ppa_history_forms

For your information I have used Microsoft support related trouble shooting methods like uninstall and reinstall.

Can any one please suggest me to come out of this problem.

Regards,

Rakesh

Comments (0) New comment

Rakeshbmagadum Rank: 1829

Asked 2 years ago

Answer this question Follow

Answers

Hello Rakesh,

Is this error happening in any node of your system? Where are you trying to add this Add-in? Do you have IM Server?

By the other hand...

Please assure that the installation of excel in the node that you have the problem has been done as recommended... this is:

"When installing Microsoft Excel 2007 it is required to select Office Shared
Features from the Installation Options dialog box and to accept the default
subfeatures under the Office Shared Features selection".
"When installing Microsoft Excel, select the Custom installation. When the
Installation Options dialog box appears. select the Visual Basic for Applications
option under Shared Features". Please check the above configuration and try again (if you modified something). BR Valeria

Comments (1) New comment

Valeria Frades Rank: 140

Answered 2 years ago

Other thing, is this happening for all the users?

If you are adding this Add-in for your user first time, be sure that you have configured the macro security configurations.

Valeria

Comments (0) New comment

Valeria Frades Rank: 140

Answered 2 years ago

Rakesh, the installation instructions are valid for many excel versions...
Here you have the manual extract fo SV 6.0
"Microsoft Excel
When installing Microsoft Excel 2010 or 2013 or 2016 it is required to select
Office Shared Features from the Installation Options dialog box and to accept the default subfeatures under the Office Shared Features selection. When installing Microsoft Excel, select the Custom installation. When the
Installation Options dialog box appears. select the Visual Basic for Applications
option under Shared Features."

Please check if the installation of office has been correctly done...

If it is correct, maybe this article that I have found can be useful:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/mic
rosoft-visual-basic-compile-error-in-hidden/4f9dfa27-e429-4ea7-

b2b6-b7c25241bae5

I hope this helps

Valeria

Comments (1) New comment