kevinmeredith
asked on
ActiveX error when opening Excel datasheet in sharepoint
We are trying to open a list in a datasheet on a sharepoint page. This datasheet uses Excel. On some computers on our network, we cannot view this list in a datasheet. The error says an office datasheet is not compatible with Windows sharepoint. But on some computers it works. We all have Office standard edition 2003. Does anyone know what I'm talking about and have any ideas? thanks!
Your other option is to manually install the sharepoint dlls instead of re-installing office. I can get you the dll names if you like, but I strongly suggest doing the complete install.
I can only get you the names of the 3 or 4 dlls that I know you are missing. There could be others that I am not aware of.
If you are pressed for time, another option may be to try and add features to the current office installation. I have not tried this fix yet, but you may be able to select a SharePoint feature.
ASKER
I've read that you need Office Professional to do this. I know the dll file i need but i don't not know how to install them. Can you please tell me how to install them manually? thanks Tad
you don't need Office Professional. Even the standard Office addition has them.
As for installing them manually, that's pretty straight forward.
[DLLs outside the directory]
C:\Program Files\Microsoft Office\OFFICE11\
MSOSVABW.dll
NAME.dll
OWSSUPP.dll
STSLIST.dll
STSUPLD.dll
[DLLs in 1033 directory]
C:\Program Files\Microsoft Office\OFFICE11\1033\
MSOHELP.exe
MSOHLP11.chm
OWSHLP10.chm
STSLIST.chm
STSLISTI.dll
I can't remember if you have to register the dll or not. To register the dlls, simply go to:
Start> Run> regsvr32 "C:\Program Files\Microsoft Office\OFFICE11\<dllname>"
If it installs successfully, then all is well. If it fails with "cannot find entry point", then you don't need to register the dlls.
ASKER
Ok, so i tried to register some of the dll files. name.dll and owssupp.dll come back with errors. STSLIST, and STSLISTI come back as cannot find entry point. So i tried to use the datasheet again and the same error comes up. Any other ideas or thoughts? thanks!
Control Panel> Add/Remove Programs> Microsoft Office 2003 Standard : Change
Add Remove Features
<next>
Choose Advanced customization of applications (checkbox)
<next>
Office Tools> Windows SharePoint Services Support (Run all from my computer)
Add Remove Features
<next>
Choose Advanced customization of applications (checkbox)
<next>
Office Tools> Windows SharePoint Services Support (Run all from my computer)
ASKER
Hi Tad,
This still does not work. I run all from my computer and i still get the same error. Any other ideas? thanks alot!!
This still does not work. I run all from my computer and i still get the same error. Any other ideas? thanks alot!!
You need Office 2003 Professional to use the feature.
ASKER
thats what i hear rStrom. But for some reason, me and my office partner get it to work and neither of us have ever had Office Professional. I've developed a couple programs that use Excel, so i think that might be the reason but i was wondering if anyone else knew for sure. thanks though rstrom.
I am quite certain that you do not need the "professional" edition in order to view documents in datasheet view.
here are the differences between the different office suites:
http://www.microsoft.com/office/editions/howtobuy/compare.mspx
Datasheet view is a function of Excel 2003. As long as you have the complete version of Excel 2003, then you should be alright.
Have you tried to: Add/Remove programs> Repair/Update programs> Advanced> (drill down)Include Microsoft SharePoint Services
here are the differences between the different office suites:
http://www.microsoft.com/office/editions/howtobuy/compare.mspx
Datasheet view is a function of Excel 2003. As long as you have the complete version of Excel 2003, then you should be alright.
Have you tried to: Add/Remove programs> Repair/Update programs> Advanced> (drill down)Include Microsoft SharePoint Services
ASKER
Yes, i have. I've tried it on multiple computers and it always say its already installed. There has to be a way. thanks for your help guys!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>
Datasheet views require that you have a Windows SharePoint Services-compatible datasheet program installed,
>>
I think this is the catch. You see, I have just very recently installed office 2003 pro and I know for a fact that I was using datasheet view previously.
However, I have *always* had FrontPage 2003 and infoPath (installed seperately from ms office). It is possible that either of these applications included the necessary dlls.
Datasheet views require that you have a Windows SharePoint Services-compatible datasheet program installed,
>>
I think this is the catch. You see, I have just very recently installed office 2003 pro and I know for a fact that I was using datasheet view previously.
However, I have *always* had FrontPage 2003 and infoPath (installed seperately from ms office). It is possible that either of these applications included the necessary dlls.
ASKER
The 2nd link did it for me. thanks rstrom. IT WORKS!!!
kevinmeredith, The second link has now been removed. Can you tell the solution you implemented.
And the first link is a page that can't be found anymore.
The problem: You had Office 2000 or Office XP on the PC before hand and clicked "upgrade" when you installed Office 2003.
The solution: You need to do a "complete" install of Office 2003.
The "Upgrade" version does not include all of the SharePoint dlls.
FYI... If you try to upload a document on an "upgraded" pc, you will not have the "upload multiple files..." option either.