I am having issues connecting my Excel 2016 file to the excel connector in the tool. Everytime I go to "Connectors", "Choose items" , "browse", under my C: Drive I go to "OpenSpan", "OpenSpan Studio for Microsoft Visual Studio 2015" , then "Office2016" the choosing "Office.dll" the errors comes up as "There are no components in 'C:\.........office.dll' that can be placed on the toolbox."
After that error I chose the "OpenSpan.Office.dll" instead and it works but when I add the excel connector to the autmoation and link my document then the error comes up as "Property value is not valid." and in the details it says "Microsoft Excel 2013 is not present."
I have windows 10 the the version of pega I have is 8.0.1081.0 and I have excel 2016.
Can someone please help me, this issue has been going on for about 2 weeks. I reinstalled the software and still same issue.
When you performed the installation of Studio, you likely selected Office 2013. The easiest way to resolve this is to uninstall and re-install. If you'd like to try on your own;
Shutdown Studio and Runtime.
Edit the following value in the %AppData%\OpenSpan folder in the files StudioConfig.xml and RuntimeConfig.xml; <add key="OfficeVersion" value="2016" />
In the installation directory (C:\Program Files (x86)\OpenSpan\OpenSpan [Plug-in|Studio] for Microsoft Visual Studio 2015), copy the contents of the appropriate office folder (C:\Program Files (x86)\OpenSpan\OpenSpan [Plug-in|Studio] for Microsoft Visual Studio 2015\Office2016) into the installation folder above it; replacing any files already there.