Data Sheet view not working on some machines

[Eric_H]

We are using MSPS 2007 and attempting to populate datasheets for various
reasons. but the 'edit in datasheet' function is not working. we get the
standard error saying "The list cannot be displayed in datasheet view for one
or more of the following reasons: a component is not installed, your browser
doesn't support Active X or the Active X controll is disabled".. To the best
of our ability, none of these are true statements. We are in the situation
where some of our MS products are 2003 but Project is 2007 Pro and we have
the SP's applied. this is not an issue on all machine just some of them and
we cannot figure out the differences between the machines. We have attempted
the to swap owssupp.dll from the office 11 folder with the one in office 12
to no avail. Also tried to run MS Office diagnostics also with mo success.
One possibility is on at least one of the machines effected we did install
the Hotfix from late October attempting to fix an "error code 42" issue. I
know this is an ongoing problem, anybody have anything new for this?

 

[Marc Soester [MVP]]

Hi Eric,

this is a known issue. If you have office 2003 but use wss 3.0, you will
experience that issue. I am not 100% sure, but believe that you will need to
install the backward compatebillity components ( as per Project server
deployment guide) which should resolve the issue.

The second option is to upgrade to office 2007 and the issue will also be
resolved I know probably not the most popular option for your company

Try the backwars compatebillity components and you should be fine.
Hope this helps

 

[Gary L. Chefetz]

Eric:

Could the 2003 products have been installed before Project 2007 on the
offending machines? Have you tried running a repair on Project 2007? This
should reinstall the correct OWC version.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Gary L. Chefetz]

I meant to say could the 2003 products have been installed after Project Pro
2007!!!!

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[John_F]

Marc:

Can you point me to where the link to install the backward compatibility
component?

Thanks,
John

 

[Eric_H]

No, the 2007 products were the latest installs.

I meant to say could the 2003 products have been installed after Project Pro
2007!!!!

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[beckmynameis]

Eric,

Try this hotfix, it has worked for me several times with IE crashing
Datasheet views:

http://support.microsoft.com/kb/952608

 

[beckmynameis]

Eric, Try using this hotfix, it has worked for me several times:

http://support.microsoft.com/kb/952608

 

[Trevor Stone]

I've been researching compatability issues between Office 2003 and
MSPS2007 and this seems to be a common one. Here is a list of causes
and fixes that I've found. I havn't been able to test yet, but I've
heard that running the repair often clears things up.

http://www.epmcentral.com/pjadmin/wssdatasheeterror.php

Hope this is helpful.

-Trevor