Our Sharepoint system has been in use for 2 years - fine.

Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
error is displayed:

"The list is displayed in Standard view. It cannot be displayed in Datasheet
view for one or more of the following reasons: A datasheet component
compatible with Windows SharePoint Services is not installed, your browser
does not support ActiveX controls, or support for ActiveX controls is
disabled."

We have loads of users screaming about this. Is it to do with Office 2003 SP3?

Re: New Edit in Datasheet error occurring on proven WSS2 sy by Mike

Mike
Thu Sep 20 04:52:55 PDT 2007

(I've deleted the Urgent - urgent questions go to Microsoft)

This is possibly caused by them having a mix of Office 2003 and Office
2007 level apps on their client and a security fix has caused the wrong
DLL to be used.

It would help with questions if you say up-front which SharePoint
product you are asking about. I'm assuming WSS 2.0 as you posted here
and it has been in use for 2 years.

Mike Walsh
WSS FAQ http://www.wssfaq.com
no private e-mail questions please

gocat2005 wrote:
> Our Sharepoint system has been in use for 2 years - fine.
>
> Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
> error is displayed:
>
> "The list is displayed in Standard view. It cannot be displayed in Datasheet
> view for one or more of the following reasons: A datasheet component
> compatible with Windows SharePoint Services is not installed, your browser
> does not support ActiveX controls, or support for ActiveX controls is
> disabled."
>
> We have loads of users screaming about this. Is it to do with Office 2003 SP3?
>

Re: New Edit in Datasheet error occurring on proven WSS2 system by gocat2005

gocat2005
Thu Sep 20 05:36:01 PDT 2007

Hi Mike,

Yeah it says WSS2 in the subject.

What shall I do?

Regards
Graham

"Mike Walsh" wrote:

> (I've deleted the Urgent - urgent questions go to Microsoft)
>
> This is possibly caused by them having a mix of Office 2003 and Office
> 2007 level apps on their client and a security fix has caused the wrong
> DLL to be used.
>
> It would help with questions if you say up-front which SharePoint
> product you are asking about. I'm assuming WSS 2.0 as you posted here
> and it has been in use for 2 years.
>
> Mike Walsh
> WSS FAQ http://www.wssfaq.com
> no private e-mail questions please
>
> gocat2005 wrote:
> > Our Sharepoint system has been in use for 2 years - fine.
> >
> > Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
> > error is displayed:
> >
> > "The list is displayed in Standard view. It cannot be displayed in Datasheet
> > view for one or more of the following reasons: A datasheet component
> > compatible with Windows SharePoint Services is not installed, your browser
> > does not support ActiveX controls, or support for ActiveX controls is
> > disabled."
> >
> > We have loads of users screaming about this. Is it to do with Office 2003 SP3?
> >
>

Re: New Edit in Datasheet error occurring on proven WSS2 system by Mike

Mike
Thu Sep 20 05:45:26 PDT 2007

Apologies. I never read the subject (once I've moved to the text that
is) ...

I think this might be one of the things that can be fixed by making sure
you have the correct version of OWSSUPP.DLL for your Office version that
controls the Datasheet function.

In Office 2003 this was controlled Excel 2003. In Office 2007 I'm unsure
whet her it is still Excel (2007) or another product but even there it
IS one of the main Office products so with the mix I mentioned before
you need to look at which 2003 or 2007 main Office products they have
installed.

Mike Walsh

gocat2005 wrote:
> Hi Mike,
>
> Yeah it says WSS2 in the subject.
>
> What shall I do?
>
> Regards
> Graham
>
> "Mike Walsh" wrote:
>
>> (I've deleted the Urgent - urgent questions go to Microsoft)
>>
>> This is possibly caused by them having a mix of Office 2003 and Office
>> 2007 level apps on their client and a security fix has caused the wrong
>> DLL to be used.
>>
>> It would help with questions if you say up-front which SharePoint
>> product you are asking about. I'm assuming WSS 2.0 as you posted here
>> and it has been in use for 2 years.
>>
>> Mike Walsh
>> WSS FAQ http://www.wssfaq.com
>> no private e-mail questions please
>>
>> gocat2005 wrote:
>>> Our Sharepoint system has been in use for 2 years - fine.
>>>
>>> Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
>>> error is displayed:
>>>
>>> "The list is displayed in Standard view. It cannot be displayed in Datasheet
>>> view for one or more of the following reasons: A datasheet component
>>> compatible with Windows SharePoint Services is not installed, your browser
>>> does not support ActiveX controls, or support for ActiveX controls is
>>> disabled."
>>>
>>> We have loads of users screaming about this. Is it to do with Office 2003 SP3?
>>>

Re: New Edit in Datasheet error occurring on proven WSS2 system by Mike

Mike
Thu Sep 20 05:52:49 PDT 2007

As I'm sure about Excel 2003 controlling this in those cases where
Office 2003 main products are in use try Repairing that (or all Office
2003). That should replace any incorrect .dlls (etc.?).

(I'm not sure whether the one I mentioned before is the right one or not)

Mike Walsh

Mike Walsh wrote:
> Apologies. I never read the subject (once I've moved to the text that
> is) ...
>
> I think this might be one of the things that can be fixed by making sure
> you have the correct version of OWSSUPP.DLL for your Office version that
> controls the Datasheet function.
>
> In Office 2003 this was controlled Excel 2003. In Office 2007 I'm unsure
> whet her it is still Excel (2007) or another product but even there it
> IS one of the main Office products so with the mix I mentioned before
> you need to look at which 2003 or 2007 main Office products they have
> installed.
>
> Mike Walsh
>
> gocat2005 wrote:
>> Hi Mike,
>>
>> Yeah it says WSS2 in the subject.
>>
>> What shall I do?
>>
>> Regards
>> Graham
>>
>> "Mike Walsh" wrote:
>>
>>> (I've deleted the Urgent - urgent questions go to Microsoft)
>>>
>>> This is possibly caused by them having a mix of Office 2003 and
>>> Office 2007 level apps on their client and a security fix has caused
>>> the wrong DLL to be used.
>>>
>>> It would help with questions if you say up-front which SharePoint
>>> product you are asking about. I'm assuming WSS 2.0 as you posted here
>>> and it has been in use for 2 years.
>>>
>>> Mike Walsh
>>> WSS FAQ http://www.wssfaq.com
>>> no private e-mail questions please
>>>
>>> gocat2005 wrote:
>>>> Our Sharepoint system has been in use for 2 years - fine.
>>>>
>>>> Today when users try to Edit in Datasheet using Office 2003 or 2007
>>>> Pro this error is displayed:
>>>>
>>>> "The list is displayed in Standard view. It cannot be displayed in
>>>> Datasheet view for one or more of the following reasons: A datasheet
>>>> component compatible with Windows SharePoint Services is not
>>>> installed, your browser does not support ActiveX controls, or
>>>> support for ActiveX controls is disabled."
>>>>
>>>> We have loads of users screaming about this. Is it to do with Office
>>>> 2003 SP3?
>>>>

Re: New Edit in Datasheet error occurring on proven WSS2 system by gocat2005

gocat2005
Thu Sep 20 06:14:00 PDT 2007

Well, it's happening to me and I use Office 2007. The only Office 2003 App I
use is FrontPage

I'm trying to re-register owssupp.dll but Vista won't let me - even using
Powershell running as Administrator

I'm doing
cd "c:\program files\microsoft office\office12"
regsvr32 owssupp.dll

Returns error 0x80070716 - which means I don't have permission to register
the dll

arrrrgh!


"Mike Walsh" wrote:

> As I'm sure about Excel 2003 controlling this in those cases where
> Office 2003 main products are in use try Repairing that (or all Office
> 2003). That should replace any incorrect .dlls (etc.?).
>
> (I'm not sure whether the one I mentioned before is the right one or not)
>
> Mike Walsh
>
> Mike Walsh wrote:
> > Apologies. I never read the subject (once I've moved to the text that
> > is) ...
> >
> > I think this might be one of the things that can be fixed by making sure
> > you have the correct version of OWSSUPP.DLL for your Office version that
> > controls the Datasheet function.
> >
> > In Office 2003 this was controlled Excel 2003. In Office 2007 I'm unsure
> > whet her it is still Excel (2007) or another product but even there it
> > IS one of the main Office products so with the mix I mentioned before
> > you need to look at which 2003 or 2007 main Office products they have
> > installed.
> >
> > Mike Walsh
> >
> > gocat2005 wrote:
> >> Hi Mike,
> >>
> >> Yeah it says WSS2 in the subject.
> >>
> >> What shall I do?
> >>
> >> Regards
> >> Graham
> >>
> >> "Mike Walsh" wrote:
> >>
> >>> (I've deleted the Urgent - urgent questions go to Microsoft)
> >>>
> >>> This is possibly caused by them having a mix of Office 2003 and
> >>> Office 2007 level apps on their client and a security fix has caused
> >>> the wrong DLL to be used.
> >>>
> >>> It would help with questions if you say up-front which SharePoint
> >>> product you are asking about. I'm assuming WSS 2.0 as you posted here
> >>> and it has been in use for 2 years.
> >>>
> >>> Mike Walsh
> >>> WSS FAQ http://www.wssfaq.com
> >>> no private e-mail questions please
> >>>
> >>> gocat2005 wrote:
> >>>> Our Sharepoint system has been in use for 2 years - fine.
> >>>>
> >>>> Today when users try to Edit in Datasheet using Office 2003 or 2007
> >>>> Pro this error is displayed:
> >>>>
> >>>> "The list is displayed in Standard view. It cannot be displayed in
> >>>> Datasheet view for one or more of the following reasons: A datasheet
> >>>> component compatible with Windows SharePoint Services is not
> >>>> installed, your browser does not support ActiveX controls, or
> >>>> support for ActiveX controls is disabled."
> >>>>
> >>>> We have loads of users screaming about this. Is it to do with Office
> >>>> 2003 SP3?
> >>>>
>

RE: **Urgent** New Edit in Datasheet error occurring on proven WSS2 sy by gocat2005

gocat2005
Thu Sep 20 06:46:03 PDT 2007

I have logged a support incident with Microsoft and will let you know what
happens

"gocat2005" wrote:

> Our Sharepoint system has been in use for 2 years - fine.
>
> Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
> error is displayed:
>
> "The list is displayed in Standard view. It cannot be displayed in Datasheet
> view for one or more of the following reasons: A datasheet component
> compatible with Windows SharePoint Services is not installed, your browser
> does not support ActiveX controls, or support for ActiveX controls is
> disabled."
>
> We have loads of users screaming about this. Is it to do with Office 2003 SP3?
>

Re: New Edit in Datasheet error occurring on proven WSS2 system by Mike

Mike
Thu Sep 20 09:19:45 PDT 2007

Front Page 2003 counts for this as an Office 2003 app and any upgrade to
it could possibly screw up your Office 2007 apps.

For that reason I have one PC running Office 2003 and FP 2003 and
another one running Office 2007 (and that's where I'd add SPD 2007 if I
wanted it on a client).

Sorry but no suggestions beyond the try to Repair Office 2007 I
mentioned before.

Mike Walsh



gocat2005 wrote:
> Well, it's happening to me and I use Office 2007. The only Office 2003 App I
> use is FrontPage
>
> I'm trying to re-register owssupp.dll but Vista won't let me - even using
> Powershell running as Administrator
>
> I'm doing
> cd "c:\program files\microsoft office\office12"
> regsvr32 owssupp.dll
>
> Returns error 0x80070716 - which means I don't have permission to register
> the dll
>
> arrrrgh!
>
>
> "Mike Walsh" wrote:
>
>> As I'm sure about Excel 2003 controlling this in those cases where
>> Office 2003 main products are in use try Repairing that (or all Office
>> 2003). That should replace any incorrect .dlls (etc.?).
>>
>> (I'm not sure whether the one I mentioned before is the right one or not)
>>
>> Mike Walsh
>>
>> Mike Walsh wrote:
>>> Apologies. I never read the subject (once I've moved to the text that
>>> is) ...
>>>
>>> I think this might be one of the things that can be fixed by making sure
>>> you have the correct version of OWSSUPP.DLL for your Office version that
>>> controls the Datasheet function.
>>>
>>> In Office 2003 this was controlled Excel 2003. In Office 2007 I'm unsure
>>> whet her it is still Excel (2007) or another product but even there it
>>> IS one of the main Office products so with the mix I mentioned before
>>> you need to look at which 2003 or 2007 main Office products they have
>>> installed.
>>>
>>> Mike Walsh
>>>
>>> gocat2005 wrote:
>>>> Hi Mike,
>>>>
>>>> Yeah it says WSS2 in the subject.
>>>>
>>>> What shall I do?
>>>>
>>>> Regards
>>>> Graham
>>>>
>>>> "Mike Walsh" wrote:
>>>>
>>>>> (I've deleted the Urgent - urgent questions go to Microsoft)
>>>>>
>>>>> This is possibly caused by them having a mix of Office 2003 and
>>>>> Office 2007 level apps on their client and a security fix has caused
>>>>> the wrong DLL to be used.
>>>>>
>>>>> It would help with questions if you say up-front which SharePoint
>>>>> product you are asking about. I'm assuming WSS 2.0 as you posted here
>>>>> and it has been in use for 2 years.
>>>>>
>>>>> Mike Walsh
>>>>> WSS FAQ http://www.wssfaq.com
>>>>> no private e-mail questions please
>>>>>
>>>>> gocat2005 wrote:
>>>>>> Our Sharepoint system has been in use for 2 years - fine.
>>>>>>
>>>>>> Today when users try to Edit in Datasheet using Office 2003 or 2007
>>>>>> Pro this error is displayed:
>>>>>>
>>>>>> "The list is displayed in Standard view. It cannot be displayed in
>>>>>> Datasheet view for one or more of the following reasons: A datasheet
>>>>>> component compatible with Windows SharePoint Services is not
>>>>>> installed, your browser does not support ActiveX controls, or
>>>>>> support for ActiveX controls is disabled."
>>>>>>
>>>>>> We have loads of users screaming about this. Is it to do with Office
>>>>>> 2003 SP3?
>>>>>>

Re: New Edit in Datasheet error occurring on proven WSS2 system by gocat2005

gocat2005
Thu Sep 20 10:08:05 PDT 2007

Thanks Mike

I have been running Office 2007 including SPD and FP2003 together on my
Vista laptop for months no probs.

This issue appeared today and on several systems in different companies.
Some are WinXP + Office 2003 and some on WinXP with Office 2007. Some like me
are Vista + Office 2003 and 2007.

I fired up a PC which has not been updated for a month - all OK.

So the problem must be the latest Windows update.

We'll see what PSS recommend.

Regards
Graham

"Mike Walsh" wrote:

> Front Page 2003 counts for this as an Office 2003 app and any upgrade to
> it could possibly screw up your Office 2007 apps.
>
> For that reason I have one PC running Office 2003 and FP 2003 and
> another one running Office 2007 (and that's where I'd add SPD 2007 if I
> wanted it on a client).
>
> Sorry but no suggestions beyond the try to Repair Office 2007 I
> mentioned before.
>
> Mike Walsh
>
>
>
> gocat2005 wrote:
> > Well, it's happening to me and I use Office 2007. The only Office 2003 App I
> > use is FrontPage
> >
> > I'm trying to re-register owssupp.dll but Vista won't let me - even using
> > Powershell running as Administrator
> >
> > I'm doing
> > cd "c:\program files\microsoft office\office12"
> > regsvr32 owssupp.dll
> >
> > Returns error 0x80070716 - which means I don't have permission to register
> > the dll
> >
> > arrrrgh!
> >
> >
> > "Mike Walsh" wrote:
> >
> >> As I'm sure about Excel 2003 controlling this in those cases where
> >> Office 2003 main products are in use try Repairing that (or all Office
> >> 2003). That should replace any incorrect .dlls (etc.?).
> >>
> >> (I'm not sure whether the one I mentioned before is the right one or not)
> >>
> >> Mike Walsh
> >>
> >> Mike Walsh wrote:
> >>> Apologies. I never read the subject (once I've moved to the text that
> >>> is) ...
> >>>
> >>> I think this might be one of the things that can be fixed by making sure
> >>> you have the correct version of OWSSUPP.DLL for your Office version that
> >>> controls the Datasheet function.
> >>>
> >>> In Office 2003 this was controlled Excel 2003. In Office 2007 I'm unsure
> >>> whet her it is still Excel (2007) or another product but even there it
> >>> IS one of the main Office products so with the mix I mentioned before
> >>> you need to look at which 2003 or 2007 main Office products they have
> >>> installed.
> >>>
> >>> Mike Walsh
> >>>
> >>> gocat2005 wrote:
> >>>> Hi Mike,
> >>>>
> >>>> Yeah it says WSS2 in the subject.
> >>>>
> >>>> What shall I do?
> >>>>
> >>>> Regards
> >>>> Graham
> >>>>
> >>>> "Mike Walsh" wrote:
> >>>>
> >>>>> (I've deleted the Urgent - urgent questions go to Microsoft)
> >>>>>
> >>>>> This is possibly caused by them having a mix of Office 2003 and
> >>>>> Office 2007 level apps on their client and a security fix has caused
> >>>>> the wrong DLL to be used.
> >>>>>
> >>>>> It would help with questions if you say up-front which SharePoint
> >>>>> product you are asking about. I'm assuming WSS 2.0 as you posted here
> >>>>> and it has been in use for 2 years.
> >>>>>
> >>>>> Mike Walsh
> >>>>> WSS FAQ http://www.wssfaq.com
> >>>>> no private e-mail questions please
> >>>>>
> >>>>> gocat2005 wrote:
> >>>>>> Our Sharepoint system has been in use for 2 years - fine.
> >>>>>>
> >>>>>> Today when users try to Edit in Datasheet using Office 2003 or 2007
> >>>>>> Pro this error is displayed:
> >>>>>>
> >>>>>> "The list is displayed in Standard view. It cannot be displayed in
> >>>>>> Datasheet view for one or more of the following reasons: A datasheet
> >>>>>> component compatible with Windows SharePoint Services is not
> >>>>>> installed, your browser does not support ActiveX controls, or
> >>>>>> support for ActiveX controls is disabled."
> >>>>>>
> >>>>>> We have loads of users screaming about this. Is it to do with Office
> >>>>>> 2003 SP3?
> >>>>>>
>

RE: **Urgent** New Edit in Datasheet error occurring on proven WSS by QC

QC
Thu Sep 20 10:34:03 PDT 2007

We are having the same issue. our server was updated to WSS 2.0 SP3.

Since SP3 was a microsoft update that can't be removed, I am out of ideas.

"gocat2005" wrote:

> I have logged a support incident with Microsoft and will let you know what
> happens
>
> "gocat2005" wrote:
>
> > Our Sharepoint system has been in use for 2 years - fine.
> >
> > Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
> > error is displayed:
> >
> > "The list is displayed in Standard view. It cannot be displayed in Datasheet
> > view for one or more of the following reasons: A datasheet component
> > compatible with Windows SharePoint Services is not installed, your browser
> > does not support ActiveX controls, or support for ActiveX controls is
> > disabled."
> >
> > We have loads of users screaming about this. Is it to do with Office 2003 SP3?
> >

RE: **Urgent** New Edit in Datasheet error occurring on proven WSS by gocat2005

gocat2005
Thu Sep 20 11:40:03 PDT 2007

Hi QC

I don't think this is a server issue. It appears to be caused by the latest
automatic updates to the client PCs.

If I try to access the SharePoint site with a PC which hasn't been updated
since last month, it works fine.

Regards
Graham


"QC" wrote:

> We are having the same issue. our server was updated to WSS 2.0 SP3.
>
> Since SP3 was a microsoft update that can't be removed, I am out of ideas.
>
> "gocat2005" wrote:
>
> > I have logged a support incident with Microsoft and will let you know what
> > happens
> >
> > "gocat2005" wrote:
> >
> > > Our Sharepoint system has been in use for 2 years - fine.
> > >
> > > Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
> > > error is displayed:
> > >
> > > "The list is displayed in Standard view. It cannot be displayed in Datasheet
> > > view for one or more of the following reasons: A datasheet component
> > > compatible with Windows SharePoint Services is not installed, your browser
> > > does not support ActiveX controls, or support for ActiveX controls is
> > > disabled."
> > >
> > > We have loads of users screaming about this. Is it to do with Office 2003 SP3?
> > >

RE: **Urgent** New Edit in Datasheet error occurring on proven WSS by QC

QC
Thu Sep 20 12:04:05 PDT 2007

It could be both. I don't acutally see an office update in September on out
client machines.

I booted up a Win XP office 2003 machine that had earlier updated back to
8/17/2007 and it still didn't work.

"gocat2005" wrote:

> Hi QC
>
> I don't think this is a server issue. It appears to be caused by the latest
> automatic updates to the client PCs.
>
> If I try to access the SharePoint site with a PC which hasn't been updated
> since last month, it works fine.
>
> Regards
> Graham
>
>
> "QC" wrote:
>
> > We are having the same issue. our server was updated to WSS 2.0 SP3.
> >
> > Since SP3 was a microsoft update that can't be removed, I am out of ideas.
> >
> > "gocat2005" wrote:
> >
> > > I have logged a support incident with Microsoft and will let you know what
> > > happens
> > >
> > > "gocat2005" wrote:
> > >
> > > > Our Sharepoint system has been in use for 2 years - fine.
> > > >
> > > > Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
> > > > error is displayed:
> > > >
> > > > "The list is displayed in Standard view. It cannot be displayed in Datasheet
> > > > view for one or more of the following reasons: A datasheet component
> > > > compatible with Windows SharePoint Services is not installed, your browser
> > > > does not support ActiveX controls, or support for ActiveX controls is
> > > > disabled."
> > > >
> > > > We have loads of users screaming about this. Is it to do with Office 2003 SP3?
> > > >

Re: **Urgent** New Edit in Datasheet error occurring on proven WSS by tasomatz

tasomatz
Fri Sep 21 02:59:33 PDT 2007

Is there any solution to this problem yet? I have 4 sbs2003 networks
all with the same after the SP3 update.


Re: **Urgent** New Edit in Datasheet error occurring on proven WSS by gocat2005

gocat2005
Fri Sep 21 03:18:01 PDT 2007

Microsoft have promised to call me within 24-48 hours!

Stay tuned...

Regards
Graham

"tasomatz@gmail.com" wrote:

> Is there any solution to this problem yet? I have 4 sbs2003 networks
> all with the same after the SP3 update.
>
>

Edit in Datasheet error - Cause and Resolution by gocat2005

gocat2005
Fri Sep 21 04:52:04 PDT 2007

After speaking to Microsoft Product Support it appears that the update

Office2003 Service Pack3 (SP3): OWC11SP3 -- Microsoft Office 2003 Web
Components Microsoft Corporation -- September 19th 2007

has re-set internet Explorer settings for ActiveX controls to Disabled

To resolve the issue, add the URL of your SharePoint site to the Trusted
Zone in Internet Explorer and set the Security level to Low.

This kludge is rubbish. My customers won't like this at all

Mike - can you get on to Microsoft for a quick resolution?

Regards
Graham

RE: Edit in Datasheet error - Cause and Resolution by QC

QC
Fri Sep 21 06:34:00 PDT 2007

I see whats going on. They just want us to get Live Search back as the
default serach engine!

"gocat2005" wrote:

> After speaking to Microsoft Product Support it appears that the update
>
> Office2003 Service Pack3 (SP3): OWC11SP3 -- Microsoft Office 2003 Web
> Components Microsoft Corporation -- September 19th 2007
>
> has re-set internet Explorer settings for ActiveX controls to Disabled
>
> To resolve the issue, add the URL of your SharePoint site to the Trusted
> Zone in Internet Explorer and set the Security level to Low.
>
> This kludge is rubbish. My customers won't like this at all
>
> Mike - can you get on to Microsoft for a quick resolution?
>
> Regards
> Graham

Re: Edit in Datasheet error - Cause and Resolution by Mike

Mike
Fri Sep 21 07:18:29 PDT 2007

I've already passed on a general question on this problem to someone
close to the SP developers. I'll add this info to the message to him/her.

Thanks!

Mike Walsh



gocat2005 wrote:
> After speaking to Microsoft Product Support it appears that the update
>
> Office2003 Service Pack3 (SP3): OWC11SP3 -- Microsoft Office 2003 Web
> Components Microsoft Corporation -- September 19th 2007
>
> has re-set internet Explorer settings for ActiveX controls to Disabled
>
> To resolve the issue, add the URL of your SharePoint site to the Trusted
> Zone in Internet Explorer and set the Security level to Low.
>
> This kludge is rubbish. My customers won't like this at all
>
> Mike - can you get on to Microsoft for a quick resolution?
>
> Regards
> Graham

Re: Edit in Datasheet error - Cause and Resolution by Mike

Mike
Fri Sep 21 07:23:25 PDT 2007

OK. Sent that.

I also queried the "kludge" and why it isn't possible to correct this by
turning ActiveX support back on for the zone in which you have your site
without going to the extreme of setting the Security level to Low.

Mike Walsh



gocat2005 wrote:
> After speaking to Microsoft Product Support it appears that the update
>
> Office2003 Service Pack3 (SP3): OWC11SP3 -- Microsoft Office 2003 Web
> Components Microsoft Corporation -- September 19th 2007
>
> has re-set internet Explorer settings for ActiveX controls to Disabled
>
> To resolve the issue, add the URL of your SharePoint site to the Trusted
> Zone in Internet Explorer and set the Security level to Low.
>
> This kludge is rubbish. My customers won't like this at all
>
> Mike - can you get on to Microsoft for a quick resolution?
>
> Regards
> Graham

Re: **Urgent** New Edit in Datasheet error occurring on proven WSS by Rob

Rob
Fri Sep 21 07:45:33 PDT 2007

This has happened to us on a random basis.

We have over 1,000 users all using Office 2003 with SharePoint 2003

There doesn't seem to be any obvious pattern, mostly it works but
occasionally a user will get an error.

Cheers,

Rob.


Re: Edit in Datasheet error - More information by gocat2005

gocat2005
Fri Sep 21 07:46:03 PDT 2007

PSS refer to:

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

But I can't ask my customers to make registry edits.

We need a hotfix fast as this wrecks Sharepoint/Office integration







"Mike Walsh" wrote:

> OK. Sent that.
>
> I also queried the "kludge" and why it isn't possible to correct this by
> turning ActiveX support back on for the zone in which you have your site
> without going to the extreme of setting the Security level to Low.
>
> Mike Walsh
>
>
>
> gocat2005 wrote:
> > After speaking to Microsoft Product Support it appears that the update
> >
> > Office2003 Service Pack3 (SP3): OWC11SP3 -- Microsoft Office 2003 Web
> > Components Microsoft Corporation -- September 19th 2007
> >
> > has re-set internet Explorer settings for ActiveX controls to Disabled
> >
> > To resolve the issue, add the URL of your SharePoint site to the Trusted
> > Zone in Internet Explorer and set the Security level to Low.
> >
> > This kludge is rubbish. My customers won't like this at all
> >
> > Mike - can you get on to Microsoft for a quick resolution?
> >
> > Regards
> > Graham
>

Edit in Datasheet error by gocat2005

gocat2005
Fri Sep 21 09:14:03 PDT 2007

The work around offerred by Microsoft Office Support is a registry edit

According to KB http://support.microsoft.com/kb/938814 the issue is caused
by poorly written COM components that use the QueryInterface() method when an
Office 2003 program is started.

This means the Datasheet View Component must be poorly written doesnâ??t it?
Therefore what we need is a well written Datasheet View Component and quick...

Also, I see note that on my WSS2 SharePoint Server which is a standard
install on Windows Server 2003, Windows Update has downloaded Office 2003 SP3
which is ready to install.
When I look in Add-Remove Programs on the server, sure enough Office 2003
Web Components are there, which is why the Update has been downloaded.

This is not good, right?


Edit in Datasheet error - resolved? by gocat2005

gocat2005
Sat Sep 22 07:24:00 PDT 2007

I tried every suggestion from Microsoft - regedits, everything.

I also did a system restore to before the time of the latest updates
released on September 19th 2007 but this problem still occurred.

So I tried Delete Temporary Internet Files in Internet Explorer - the issue
disappeared.

What was all that about then ????

Re: **Urgent** New Edit in Datasheet error occurring on proven WSS by Brett

Brett
Mon Sep 24 00:58:01 PDT 2007

Any word yet, gocat? We are having the same problem on 3 of our portals.

Brett

Re: **Urgent** New Edit in Datasheet error occurring on proven WSS by arjen

arjen
Mon Sep 24 02:40:22 PDT 2007

On 24 sep, 09:58, Brett <Br...@discussions.microsoft.com> wrote:
> Any word yet, gocat? We are having the sameproblemon 3 of our portals.
>
> Brett

I have this problem as well, and just deleting the browser cache is
not fixing anything.

On the 17th SP3 was released, does this automatic client update have
anything to do with SP3 as well?


RE: **Urgent** New Edit in Datasheet error occurring on proven WSS2 sy by gocat2005

gocat2005
Mon Sep 24 06:24:04 PDT 2007

The solution was Delete Temporary Internet Files on client machines.

This worked in 3 different corporations in different locations who have
experienced this problem since the Office 2003 SP3 update was released on
19th September 2007.

Microsoft advice is: Do not install Office 2003 SP3 on server machines yet

If clearing the browser cache does not fix your problem then try the
documented issues for SP3 (supplied by Microsoft Product Support):-

http://support.microsoft.com/kb/923618 , specially the section â??Known issues
after you install the service packâ??

You can refer to KB http://support.microsoft.com/kb/938814 . The issue is
documented there and there is a resolution/workaround is mentioned.






Re: **Urgent** New Edit in Datasheet error occurring on proven WSS by gocat2005

gocat2005
Mon Sep 24 06:26:04 PDT 2007

Please see my latest post

RE: **Urgent** New Edit in Datasheet error occurring on proven WSS by B-Admin

B-Admin
Tue Sep 25 01:24:00 PDT 2007

Hello,

we are experiencing the same problem when a user tries to use the datasheet
view:

"The list is displayed in Standard view. It cannot be displayed in Datasheet
view for one or more of the following reasons: A datasheet component
compatible with Windows SharePoint Services is not installed, your browser
does not support ActiveX controls, or support for ActiveX controls is
disabled."

But no one of them has SP3 of Office 2003 installed, only SP2. And I also
deleted their temporary internet files. It has worked now for 3 yeas but
since we installed SP3 for v2 of our Sharepoint Server, we have this problem
on every computer. I thought that at the beginning of this thread this was
also the opinion of some people. Did they find a solution?

"gocat2005" wrote:

> The solution was Delete Temporary Internet Files on client machines.
>
> This worked in 3 different corporations in different locations who have
> experienced this problem since the Office 2003 SP3 update was released on
> 19th September 2007.
>


RE: **Urgent** New Edit in Datasheet error occurring on proven WSS by Zoltan

Zoltan
Tue Sep 25 06:32:04 PDT 2007

Hello.

We are using Intranet build on MS Sharepoint Portal Server 2003 SP2 and
Sharepoint Services SP2.

We have the same problem as mentioned before. After instalation of Windows
Sharepoint Services SP3, we have experienced problems with displaying Graphs
in our intranet and we can´t use Edit in Datasheet. If I make a new graph,
then Explorer displays it without errors.

I consulted disfunctional graps with Microsoft Support. Their advice:
Install SP3 to Sharepoint Portal Server. After update, graphs are still not
working. MS only solution is to back to SP2 or make all intranet graphs again.

We found, that this problem occures after installing KB924424. Before this
update everything was working fine. This KB is included in SP3 and can´t be
uninstalled separetely.

I don´t want to reinstall Intranet and I don´t want to remake all graphs in
our intranet.

Can you please help me?

"B-Admin" wrote:

> Hello,
>
> we are experiencing the same problem when a user tries to use the datasheet
> view:
>
> "The list is displayed in Standard view. It cannot be displayed in Datasheet
> view for one or more of the following reasons: A datasheet component
> compatible with Windows SharePoint Services is not installed, your browser
> does not support ActiveX controls, or support for ActiveX controls is
> disabled."
>
> But no one of them has SP3 of Office 2003 installed, only SP2. And I also
> deleted their temporary internet files. It has worked now for 3 yeas but
> since we installed SP3 for v2 of our Sharepoint Server, we have this problem
> on every computer. I thought that at the beginning of this thread this was
> also the opinion of some people. Did they find a solution?
>
> "gocat2005" wrote:
>
> > The solution was Delete Temporary Internet Files on client machines.
> >
> > This worked in 3 different corporations in different locations who have
> > experienced this problem since the Office 2003 SP3 update was released on
> > 19th September 2007.
> >
>

RE: **Urgent** New Edit in Datasheet error occurring on proven WSS by Dan

Dan
Tue Sep 25 08:28:08 PDT 2007

Neither deleting temp internet files or the registry fixes work. Does anyone
know of any other way to resolve this issue?
Thanks
Dan Stewart
"Zoltan Canda" wrote:

> Hello.
>
> We are using Intranet build on MS Sharepoint Portal Server 2003 SP2 and
> Sharepoint Services SP2.
>
> We have the same problem as mentioned before. After instalation of Windows
> Sharepoint Services SP3, we have experienced problems with displaying Graphs
> in our intranet and we can´t use Edit in Datasheet. If I make a new graph,
> then Explorer displays it without errors.
>
> I consulted disfunctional graps with Microsoft Support. Their advice:
> Install SP3 to Sharepoint Portal Server. After update, graphs are still not
> working. MS only solution is to back to SP2 or make all intranet graphs again.
>
> We found, that this problem occures after installing KB924424. Before this
> update everything was working fine. This KB is included in SP3 and can´t be
> uninstalled separetely.
>
> I don´t want to reinstall Intranet and I don´t want to remake all graphs in
> our intranet.
>
> Can you please help me?
>
> "B-Admin" wrote:
>
> > Hello,
> >
> > we are experiencing the same problem when a user tries to use the datasheet
> > view:
> >
> > "The list is displayed in Standard view. It cannot be displayed in Datasheet
> > view for one or more of the following reasons: A datasheet component
> > compatible with Windows SharePoint Services is not installed, your browser
> > does not support ActiveX controls, or support for ActiveX controls is
> > disabled."
> >
> > But no one of them has SP3 of Office 2003 installed, only SP2. And I also
> > deleted their temporary internet files. It has worked now for 3 yeas but
> > since we installed SP3 for v2 of our Sharepoint Server, we have this problem
> > on every computer. I thought that at the beginning of this thread this was
> > also the opinion of some people. Did they find a solution?
> >
> > "gocat2005" wrote:
> >
> > > The solution was Delete Temporary Internet Files on client machines.
> > >
> > > This worked in 3 different corporations in different locations who have
> > > experienced this problem since the Office 2003 SP3 update was released on
> > > 19th September 2007.
> > >
> >

RE: **Urgent** New Edit in Datasheet error occurring on proven WSS by Cortland71

Cortland71
Tue Sep 25 09:46:11 PDT 2007

I had the same problem. All of a sudden I couldn't open lists in the
datasheet view. I'm Running Office 2007 and Vista. I deleted the Temporary
Internet files as suggested and all is fine again.

Thanks for your help. This was driving me crazy!

"gocat2005" wrote:

> The solution was Delete Temporary Internet Files on client machines.
>
> This worked in 3 different corporations in different locations who have
> experienced this problem since the Office 2003 SP3 update was released on
> 19th September 2007.
>
> Microsoft advice is: Do not install Office 2003 SP3 on server machines yet
>
> If clearing the browser cache does not fix your problem then try the
> documented issues for SP3 (supplied by Microsoft Product Support):-
>
> http://support.microsoft.com/kb/923618 , specially the section â??Known issues
> after you install the service packâ??
>
> You can refer to KB http://support.microsoft.com/kb/938814 . The issue is
> documented there and there is a resolution/workaround is mentioned.
>
>
>
>
>

Re: **Urgent** New Edit in Datasheet error occurring on proven WSS by dantist

dantist
Wed Sep 26 04:10:38 PDT 2007

On 25 , 22:46, Cortland71 <Cortlan...@discussions.microsoft.com>
wrote:
> I had the same problem. All of a sudden I couldn't open lists in the
> datasheet view. I'm Running Office 2007 and Vista. I deleted the Temporary
> Internet files as suggested and all is fine again.
>
> Thanks for your help. This was driving me crazy!
>
>
>
> "gocat2005" wrote:
> > The solution was Delete Temporary Internet Files on client machines.
>
> > This worked in 3 different corporations in different locations who have
> > experienced this problem since the Office 2003 SP3 update was released on
> > 19th September 2007.
>
> > Microsoft advice is: Do not install Office 2003 SP3 on server machines yet
>
> > If clearing the browser cache does not fix your problem then try the
> > documented issues for SP3 (supplied by Microsoft Product Support):-
>
> >http://support.microsoft.com/kb/923618, specially the section 'Known issues
> > after you install the service pack'
>
> > You can refer to KBhttp://support.microsoft.com/kb/938814. The issue is
> > documented there and there is a resolution/workaround is mentioned.- -
>
> - -

I have the same problem
after install the Windows SharePoint Services service pack 3 i cannot
view a list in Datasheet view !
anyone have any ideas ?


RE: **Urgent** New Edit in Datasheet error occurring on proven WSS2 sy by bsr1031

bsr1031
Thu Sep 27 06:04:01 PDT 2007

We've been following this thread and have finally fixed the problem at our
company. We ended up doing a repair of the WSS2 installation and then an
uninstall and reinstall of the .Net Frameworks. After that the datagrid was
working fine again. Some clients had to delete their temporary internet
files afterwards, others did not. Hope this helps those who are still having
issues.


"gocat2005" wrote:

> Our Sharepoint system has been in use for 2 years - fine.
>
> Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
> error is displayed:
>
> "The list is displayed in Standard view. It cannot be displayed in Datasheet
> view for one or more of the following reasons: A datasheet component
> compatible with Windows SharePoint Services is not installed, your browser
> does not support ActiveX controls, or support for ActiveX controls is
> disabled."
>
> We have loads of users screaming about this. Is it to do with Office 2003 SP3?
>

Re: **Urgent** New Edit in Datasheet error occurring on proven WSS by bsr1031

bsr1031
Thu Sep 27 11:06:01 PDT 2007

WSS SP3 being applied to our servers was the culprit for us. We managed to
recreate the issue in a couple of test environments as well. The datagrid
functionality works fine until WSS SP3 is applied to the server.

"Mike Walsh" wrote:

> Do you know whether in your case the SP3 was applied to clients; servers
> (the WSS 2.0 server); or both ?
>
> Mike Walsh
>
>
> bsr1031 wrote:
> > We've been following this thread and have finally fixed the problem at our
> > company. We ended up doing a repair of the WSS2 installation and then an
> > uninstall and reinstall of the .Net Frameworks. After that the datagrid was
> > working fine again. Some clients had to delete their temporary internet
> > files afterwards, others did not. Hope this helps those who are still having
> > issues.
> >
> >
> > "gocat2005" wrote:
> >
> >> Our Sharepoint system has been in use for 2 years - fine.
> >>
> >> Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
> >> error is displayed:
> >>
> >> "The list is displayed in Standard view. It cannot be displayed in Datasheet
> >> view for one or more of the following reasons: A datasheet component
> >> compatible with Windows SharePoint Services is not installed, your browser
> >> does not support ActiveX controls, or support for ActiveX controls is
> >> disabled."
> >>
> >> We have loads of users screaming about this. Is it to do with Office 2003 SP3?
> >>
>

Re: **Urgent** New Edit in Datasheet error occurring on proven WSS2 by Mike

Mike
Thu Sep 27 10:56:40 PDT 2007

Do you know whether in your case the SP3 was applied to clients; servers
(the WSS 2.0 server); or both ?

Mike Walsh


bsr1031 wrote:
> We've been following this thread and have finally fixed the problem at our
> company. We ended up doing a repair of the WSS2 installation and then an
> uninstall and reinstall of the .Net Frameworks. After that the datagrid was
> working fine again. Some clients had to delete their temporary internet
> files afterwards, others did not. Hope this helps those who are still having
> issues.
>
>
> "gocat2005" wrote:
>
>> Our Sharepoint system has been in use for 2 years - fine.
>>
>> Today when users try to Edit in Datasheet using Office 2003 or 2007 Pro this
>> error is di