You can actually see the location of where each of your Excel add-ins are running from by going to the Excel File menu/Options/Add-Ins, then looking at the Location column (or label below):
But this error usually happens if you previously had 32-bit EViews installed on the same machine, but then moved onto 64-bit EViews with different licensing. Because most people's Office installations are 32-bit, when our Excel add-in asks for the EViews OLEDB driver (in order to read EViews data from a workfile), Windows usually tries to look for a 32-bit version first, and an old 32-bit installation may confuse Windows as to where to look for the proper DLL.
So the quick solution would be to re-install 32-bit EViews onto your system, and to make sure this version can run with your license server. You can have both 32-bit and 64-bit EViews installed on the same system and both will use the same license.
Another solution is to do the following. Note: you must have local admin privileges to do these steps successfully:
1. First, quit Excel and EViews if they are running.
2. Download this zip
file, unzip it, then run the REG file on your system. This will clean/remove all EViews related registry entries related to COM.
3. Re-run EViews and run the command: REGCOMPONENTS. In the Register Components dialog, click the "Yes(All)" button to re-register everything. Wait for the success message.
4. Re-run REGCOMPONENTS and make sure both "OLEDB Provider" entries say "Registered". Also make sure the Excel 2007 (or 2010 if you're using EViews 10) Add-In entry says "Installed". If it says "Unavailable", you may need to re-install EViews.
5. Now run Excel. Go to File/Options/Add-Ins, then select "COM Add-ins" in the Manage dropdown, then click Go.
6. If you see multiple versions of the EViews Add-In for Excel, make sure only the one that came from the version of EViews you just ran REGCOMPONENTS on is checked. You can see the file path for each add-in by highlighting the row and looking at the "Location:" label below. Click OK to save the changes, if any.
7. Finally, you should now see the latest EViews Add-In in the Data ribbon/tab. Try "Get Data" to see if it now works.