I’m working on a data migration project where we are migrating all contents from SharePoint 2003 server to MOSS 2007 Enterprise Server. We are doing this manually as the MOSS server is already in place from a year or more and it is highly customized.
While doing so I recognized that on my machine the datasheet view doesn’t work. Then I started blaming my IE6 and upgraded to IE7 which didn’t helped and finally I landed up with IE8 which also didn’t worked.
It gives following error.
“The Standard View of your list is being displayed because your browser does not support running ActiveX controls.”
While I tried to search for some solution, I found that lot of people are facing this problem.
There are many solutions that worked for them and there are many of them for who nothing worked actually.
————————————————————————————–
See Also: MCTS: MOSS 2007 Configuration (70-630) all you need to know to clear this exam
————————————————————————————–
So I came to a conclusion that there is no perfect solution available.
Here are some possible solutions that work.
All of these are not found by me. I’m just trying to put them at one place.
1.
Microsoft says:
A datasheet component that is compatible with Windows SharePoint Services is not installed.
AND/OR
A Microsoft Office 2003 Professional edition is not installed on the computer.
AND/OR
The Web browser does not support ActiveX controls.
AND/OR
Support for ActiveX controls is disabled
If you are using Office 2003, then try the first solution first. Install Office 2003 web components.
Make sure that you have installed Office 2003 or higher on your client machine.
Unfortunately there are no Office 2007 web components available and I am using Office 2007. Still I tried to install those which didn’t worked too.
I also tried my ActiveX settings for IE8 but that didn’t helped.
As I tried all of them. Still it didn’t worked. Then I carried on my R&D.
2.
On your client machine run, “Microsoft Office Diagnostics”.
This one worked for me. And datasheet view started working normally.
But this too doesn’t work for everyone.
3.
Try putting the site in the trusted sites list. This may solve the problem if it is related to activeX.
4.
Based on my exprience, this kind of problems (a ActiveX component doesn’t work on a particualr client) mostly is caused by a corrupted registry entry or file. So, a complete reinstallation may be the most prompt way to resolve such an issue. While this is not a good advice.
5.
Open the file ows.js in your favorite editor. It can be found here.
C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\LAYOUTS\1033
Put following javascript code
function RenderActiveX(str)
{
document.write(str);
}
and reset your app pool.
while if the problem is only with a perticular client then I wont suggest this.
6.
If you are working on as WSS 2.0 site then this hotfix might help you.
http://support.microsoft.com/kb/948919/en-us
This is a post SP3 hotfix.
7.
The Office Service Pack team has announced that Service Pack 2 for the 2007 Microsoft Office System due to ship April 28th. This is a good news and we hope they solve this problem for all users.
Even I found some people who has tried all of these and still the datasheet view doesn’t work for them.
So I said earlier, there isn’t a perfect solution for this.
If you know some more then please comment!
If you found the article useful, please re-tweet it and help others too.
