Learn how to enable DataDear when you get a manifest may not be valid error when loading DataDear Loader.vsto.
If you have successfully installed DataDear but you are experiencing the below error when opening Excel, there are a few steps you can do to fix the problem.
This is the error message prompted on loading Excel (after installing DataDear):
file:///C:/Users/user/AppData/Roaming/Scope SaaS/DataDear/DataDear Loader.vsto
************** Exception Text ************** System.Deployment.Application.InvalidDeploymentException: Exception reading manifest from file:///C:/Users/user/AppData/Roaming/Scope%20SaaS/DataDear/DataDear%20Loader.vsto: the manifest may not be valid or the file could not be opened. ---> System.Deployment.Application.InvalidDeploymentException: Manifest XML signature is not valid. ---> System.Security.Cryptography.CryptographicException: SignatureDescription could not be created for the signature algorithm supplied. at System.Security.Cryptography.Xml.SignedXml.CheckSignedInfo(AsymmetricAlgorithm key) at System.Security.Cryptography.Xml.SignedXml.CheckSignatureReturningKey(AsymmetricAlgorithm& signingKey) at System.Deployment.Internal.CodeSigning.SignedCmiManifest.Verify(CmiManifestVerifyFlags verifyFlags) at System.Deployment.Application.Manifest.AssemblyManifest.ValidateSignature(Stream s) --- End of inner exception stack trace --- at System.Deployment.Application.Manifest.AssemblyManifest.ValidateSignature(Stream s) at System.Deployment.Application.ManifestReader.FromDocument(String localPath, ManifestType manifestType, Uri sourceUri) --- End of inner exception stack trace --- at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.GetManifests(TimeSpan timeout) at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()
Resolution: Install the following software
This error is typically triggered when Excel is not able to open the DataDear add-in due to missing or corrupted external software components. It is recommended to install the following software:
Check if the Microsoft .NET Framework 4.5 (or higher) is installed from the Programs option in the Control Panel (Windows 10 already includes this by default) - otherwise download from here. Follow instructions on screen to install.
Install Visual Studio 2010 Tools for Office Runtime - download from here. Follow instructions on screen to install.
You may be required to restart your computer.
Re install DataDear
If the above procedure does not work, open the Programs option in the Control Panel (varies depending on the Windows OS version).
Find the DataDear Excel Add-in and select Uninstall .
Download DataDear from the Web Dashboard and install the latest version.
If the problem persists after performing the above steps, it is advisable to contact the DataDear Support team for further guidance.