Issues when trying to access an Excel spreadsheet from ExtendSim
There are two common issues if you try to access a Microsoft Excel spreadsheet from ExtendSim:
You get the error OLE CreateObject Not Successful.
Or, Excel does not appear in the list of applications in the Data Import Export block.
Possible causes are:
Excel is not installed on your device.
Excel is installed but is not properly registered for OLE/COM in the system registry. For Excel to be able to interface with other applications, it must be launched one time with Administrative privileges so that it can complete the process of registering itself. See below for how to do that.
A click-to-run version of Excel is installed on your computer. This version does not support communication between outside applications such as ExtendSim and Excel. You will need to uninstall your click-to-run version of Excel and install a full version of Excel. Instructions for this can be found at support.microsoft.com/kb/982431.
ExtendSim is not properly registered for OLE/COM in the system registry. For ExtendSim to be able to interface with Excel and other apps, it must be launched one time with Administrative privileges so that it can complete the process of registering itself. See below for how to do that.
To launch an application with Administrative privileges, either right-click the application and select Run as Administrator or contact your IT or Admin and have them launch the application in your user account with the correct Admin permissions. This only needs to be done once. After the application is properly registered, neither option will be required again.