Error occured while exporting to excel in OWC10 Component on Web

[Sandeep]

Hello

I am refering to the article posted no Microsoft Website on OLAP
Reporting in ASP.NET using SQL Server 2000 Analysis Services.
[http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/]. Every single
option in this project was working fine after installation of the
same. After making some changes to the code, the export to excel
button on the toolbar started giving the following error.

"An error 0x80070005 occurred. No further information was provider."

I tried using the OWC Component in VB.NET Application and i can use
the Export to Excel option there.

Following are the details of software that i am working on
OS : Windows 2000 Professional
Visual Studio .NET 1.1 Framework
Microsoft Excel 2000 with Office XP Web Components Version 10
installed.
Microsoft Analysis Server with SP3.
Microsoft XML for Analysis SDK.

Any solution to this problem would be of great help. Thanks for all
your efforts.

 

[Sandeep]

Its solved by changing the security settings for the Local Intranet.
The Settings for ActiveX Options were changed to enable from
disable/prompt and baam it started working.