Felipe Ferreira

Pingback from  Sharepoint: ActiveX Error When Trying to View List in Datasheet View | ASP Scribe

OMG! Thank you! I've been waiting long time for this solution!

Thanks! this worked lovely.

Found this also on MS website. They say it works like design. Arrogance of MS is unbelievable. They cba to fix it i guess.

Great. It worked. Thanks a lot.

Hi - thanks

I'v been spend a lot of time trying find solution

Since only deleting this registry HKLM\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\

{65BCBEE4-7728-41A0-97BE-14E1CAE36AAE}

solve this problem

much obliged

Ted - Poland

Anyone had this issue with Windows 7? Registry seems to be a bit different. There are several entries with 65BCBEE4-7728-41A0-97BE-14E1CAE36AAE. I am not sure which one to remove

We solved this issue (Office 2003 SOE with Project 2007) simply by opening Excel 2003 and performing a repair. Excel 2003 > Help > Detect and Repair (may require a restart). This re-instates control of the Office Web Component (runs Datasheet view) from Access 2007 back to Excel 2003. Not one of Microsoft's finest moments on the backward compatibility front.

Thanks for sharing your solution Darren.

in my case there wasn't office 2007 installed, and even reinstalling office 2003 didn't solved the problem. it was a 1 day headache, that's why I decided to share how I fixed here :)

hope your solution can help others here too

regards

I had the same Datasheet View problem in Share Point using Office 2003 and IE7.  

I did not have the registry path HKLM\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\

{65BCBEE4-7728-41A0-97BE-14E1CAE36AAE}.

I also did not have the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\LAYOUTS\1033\ows.js file.  

So, I searched my registry and found the {65bcbee4-7728-41a0-97be-14e1cae36aae} value under HKEY_Classes_Root\CLSID\...  I had two entries total in my registry and deleted them, after first backing up the registry of course.  Then, I ran the Excel 2003 Detect and Repair.  No more problem.  

Next, I like Darren D's idea and will try to fix the problem by only running the Excel 2003 Detect and Repair to see if the registry hack is even necessary.  

Does anyone know what this registry value {65bcbee4-7728-41a0-97be-14e1cae36aae} does?  

Ahhhh, it is the Datasheet Control GUID {65bcbee4-7728-41a0-97be-14e1cae36aae}

Thanks Felipe, headache avoided!

impossible!

this registry trick helped me as well...

I am just wondering how someone can find out such a solution!! Thank ou very very much

Terrific Felipe, I've been searching for monthes a solution. Thanks a lot !

Alain

Thanks, Felipe and Darren.

At Office 2007, Office button > Options > Resources > Diagnose

Thanks guys this was very very helpful, spent hours and hours on this

Thanks a lot for your solution, works great for me.

Fantastic Solution, had 2007 project installed with 2003 office pro. First i was getting just an error screen with no standard view of the datasheet.

Removing the reg key gave me access to the standard view but not the datasheet view. I then used the regsvr32 command and got:

"an the DllRegister Server entry point was not found.

This file can not be registered."

So just as an additional fix I performed the excel repair from within excel as suggested above. Load up the datasheet view and VOILA! Fixed and I can now resume life again! Many thanks for the fixes above!

THANK YOU !!!!

I was looking for sinc a while.

this was working for me:

I had the same Datasheet View problem in Share Point using Office 2003 and IE7.  

I did not have the registry path HKLM\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\

{65BCBEE4-7728-41A0-97BE-14E1CAE36AAE}.

I also did not have the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\TEMPLATE\LAYOUTS\1033\ows.js file.  

So, I searched my registry and found the {65bcbee4-7728-41a0-97be-14e1cae36aae} value under HKEY_Classes_Root\CLSID\...  I had two entries total in my registry and deleted them, after first backing up the registry of course.  Then, I ran the Excel 2003 Detect and Repair.  No more problem.  

Next, I like Darren D's idea and will try to fix the problem by only running the Excel 2003 Detect and Repair to see if the registry hack is even necessary.  

In some computer I only can view 100 rows in DataSheet View (this computer has Excel 2003), same view in other computer with Excel 2007 show complete list (above 200 rows). ¿This is a problem with Excel version on client side o something in the server MOSS 2007?

I had the same error message and have Office2003 Pro.

My solution was to open Excel and choose Detect and Repair under the Help menu. I had to restart the PC after this, but then it worked perfectly. :)

i have office 2007 and use IE 7

i could not find 65bcbee4-7728-41a0-97be-14e1cae36aae under registry....!

I need to check if regsvr32.exe stslist.dll works or for me or not.

I do not see Office button > Options > Resources > Diagnose.

Any suggestions?????

Hi All,

Thanks for the Valuable info. It just reduced my search towards the solution for this problem. I just tried checking it on the local system for the dll and the HKEY mentioned here, but couldn't find either of them. The problem which i face in my workplace is, for some of them the Datasheet view works and for some it doesn't. We have IE version 6.0.2900 installed on the desktops.

Please let me know the solution for this as it takes me for toss everytime.

Should i check these on the sharepoint server too?

I had this problem on a workstation. Weird thing was that it worked on another workstation with the same configuration.

Thanks alot this worked for me!

WOW, thanks a lot.

Since I haven't found the exact same reg entry, I just backed up and deleted the 2 entries that started with 65 and it worked! Thanks again.

thanks,

we spent 4h hours on this problem with 2 peoples..

with headchief on our back ....

Had a system where it worked for other users but not for the regular user of the computer.

Located:

Was ready to re-image.

Started deleting all entries for:

{65BCBEE4-7728-41A0-97BE-14E1CAE36AAE}

Found:

HKCU\Software\Microsoft\Windows\CurrentVersion\Ext\Stats\{65BCBEE4-7728-41A0-97BE-14E1CAE36AAE}

Deleated the Key and it started working properly.

Pingback from  Unable to View SharePoint site in Datasheet View | Martin Reference

Yes there should realize the reader to RSS my feed to RSS commentary, quite simply

opening Excel 2003 and performing a repair. Excel 2003 > Help > Detect and Repair  did the trick for me. No registry hack required.

The same like Ella317 ->

opening Excel 2003 and performing a repair. Excel 2003 > Help > Detect and Repair  did the trick for me. No registry hack required.