ExcelTechnology
Issues and Solutions of Using Excel Integration
Sometimes, there are some issues when we use Excel integration with various Excel versions. What is the reason for the issues? It may be for the lack of .Net Programmability support or registry permission. Usually, it is useful to reinstall Excel integration. However, sometimes, it is useless. Therefore, we can try the following things.
1. Microsoft Excel integration is disabled. What we should do is to select Help and then click the Disabled Item button. If the Add-in appears in the Disabled Items list, select it and enable button. For this, you need to update Excel if you use .Net 2.0 to make .Net Excel integration available.
2. .Net Programmability Support has not installed in Excel, with which, Excel integration can make full use of its function correctly.
3. If you use Excel 2003, you need to open Add Remove Programs and then select Microsoft Excel. Click Change. Select Add or Remove Features and Click Next to select Choose Advanced Customization of Applications. Expand Excel for ensuring that .Net Programmability Support is set to Run From My Computer and Click Update.
4. For Excel 2007, the step is similar to Excel 2003. The little difference is that you don’t need to select Choose to Advanced Customization of Application, but Expand Excel directly.
5. It is possible that all the above are not useful. Then, we come to the last, to check the registry. It is a little difficult than others and you should make a backup of your registry because you many meet a risk. Firstly, open the registry and find the following key: [HKEY_LOCAL_MACHINESOFTWAREMicrosoftOfficeWordAddins]. And then, make sure that the LoadBehavior value is 3, if not, change it. The next is to reset permissions for the USERS group to full control for the following registry keys:
[HKEY_LOCAL_MACHINE...OfficeWordAddins
STWord.STWordDesigner]([HKEY_LOCAL_MACHINE...OfficeWordAddins
STWord.Connect]([HKEY_LOCAL_MACHINE...OfficeExcelAddinsSTExcel.Connect]
You don’t need to create the keys because you may not see all of above on every computer.
In short, there are the common issues that Excel integration cannot
