Error: The value of the property ‘type’ cannot be parsed
While installing the Data Everywhere Excel add-in, you may encounter an error like the following:
The value of the property ‘type’ cannot be parsed. The error is: Could not load file or assembly ‘Microsoft.Office.BusinessApplications.Fba,Version=220.127.116.11, Culture=neutral, PublicKeyToken=71e9bc3111e9429c’ or one of its dependencies. The system cannot find the file specified (C:\Program Files (x86)\Common Files\Microsoft Shared\VSTO\10.0\VSTOInstaller.exe.Config line 10).
This error indicates a problem installing Visual Studio 2010 Tools for Office (VSTO), a necessary prerequisite of the Data Everywhere Excel add-in.
If errors are encountered during the installation of VSTO, it is best to install it separately. Visual Studio Tools for Office setup can be downloaded directly from Microsoft. Click the ‘Download’ button on this page to download the vstor_redist.exe file to your computer. Once this file is downloaded, run the installer. Please try the following remedies to resolve the issue.
Rename the Config File
This step involves using Windows Explorer to navigate to a directory and change a filename. If you do not feel comfortable doing so, please contact support.
Start by browsing to the following location using Windows Explorer:
C:\Program Files (x86)\Common Files\Microsoft Shared\VSTO\10.0
This location may not exist on your computer. Instead, try the following location in the regular Program Files directory:
C:\Program Files\Common Files\Microsoft Shared\VSTO\10.0
In this folder will be a file named VSTOInstaller.exe.Config. Rename this file to VSTOInstaller.exe.Config.old (adding the “.old” extension), and then retry the installation of vstor_redist.exe.
Running installation as Administrator
In certain cases, vstor_redist.exe needs to be run explicitly as an Administrator on your local machine. Right click on the vstor_redist.exe installation file and choose “Run as Administrator” rather than just double-clicking.