Office Web Components - Query could not be processed

[Kam]

I use frontpage 2002, insert the office web components ->
Excel Pivot Table.
Get Data using ->Connection = "excel file, under the site
create in frontpage"

It work well in the design page.
when I select the Preview, it come out with an error "The
query could not be processed- Safety settings on this
machines prohibit accessing a data source on another
domain"

pls help. The site, html page and excel documents all
location in the same machine.

 

[Wei-Dong Xu [MSFT]]

Hi Kam,

Have you set the data source of the pivotTable? You can click the pivotTable control in design time. Then the ActiveX control properties windows
will pop up. Please select "Data source" tab and then input all the necessary information. The setting may be unfamiliar for you. I'd suggest you
can obtain the information about these from Office web component help and the web component tool pack. There is some examples in the web
component tool pack which will illustrate how to use these components for you. The tool pack is available in Microsoft.com. Please go to:
http://www.microsoft.com/downloads/...77-2100-4586-A13C-50E56F101720&displaylang=en

Please feel free to let me know if you have any questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

 

[Kam]

I do not have much success on this.
I still got the error "The query could not be processed :
Safety setting on this machine prohibit accessing a data
source on another domain"

Can anyone give me some hit on this?

thanks

-----Original Message-----
Hi Kam,

Have you set the data source of the pivotTable? You can

click the pivotTable control in design time. Then the
ActiveX control properties windows

will pop up. Please select "Data source" tab and then

input all the necessary information. The setting may be
unfamiliar for you. I'd suggest you

can obtain the information about these from Office web

component help and the web component tool pack. There is
some examples in the web

component tool pack which will illustrate how to use

these components for you. The tool pack is available in
Microsoft.com. Please go to:

 

[Wei-Dong Xu [MSFT]]

Hi Kam,

Thank you for replying!

I'd suggest there is one kb article which may help you some on this issue. Please go to:
258510 INFO: Office Web Components Display Cross-Domain Warning
http://support.microsoft.com/?id=258510

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.