Monday, July 27, 2009

Edit in Datasheet view is not working

As part of one of our deployment we had to modify lot of data in a SharePoint list, which was used by the InfoPath forms for populating the dropdowns. To make the deployment steps short we gave the steps to use the Edit in Datasheet view option. But when the deployment team was executing the steps, they were not able to use the Edit in Datasheet view and they were getting some activeX related issues.

We were troubleshooting this issue and found that this problem is mostly related to a office component which corrupts because of some reason. We followed the steps mentioned below and it resolved the error.

1.Go go to this directory:C:\Program Files\Microsoft Office\Office12
2.Then delete OWSSUPP.DLL after taking a backup
3.Then run Microsoft Office Diagnostics (Start-Programs-Microsoft Office-Microsoft Office Tools - Microsoft Office Diagnostics).It will verify your installation and recreate the OWSSUPP.DLL file.