Analysis ToolPak Not Working in Browser mode

[rosh]

Hi All,

I opened an excel workbook in internet explorer. Then i selected th
addin i.e. (Tools/Addin) "Analysis ToolPak" and "Analysis ToolPak
VBA".

On doing this in tools menu i got an entry "Data Analysis". But to m
surprise on selecting "Data Analysis", nothing happens. No dialog get
opened.

But doing the same procedure in a standalone excel applicatio
successfully opens the Analysis dialog.

Can anyone advise me as to how to get the Analysis ToolPa
functionality invoked in excel opened in browser?

Regards
Ros

 

[Dave Peterson]

Saved from a previous post:


It didn't work for me in xl2002, either.

But maybe you could change a setting so that .xls files open in excel
proper--not in MSIE.

There's a setting in Windows that you can change.

In win98, I can do this:
Start Windows Explorer
View|Folder Options
File Types Tab
scroll down to MS Excel Worksheet
Select it
click the edit button
There's an option to "browse in same window". Uncheck it.

That's where you can toggle the "confirm open after download", too.

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

 

[rosh]

Thanks for the reply. Well thatz my problem. I need to open the exce
workbook as embedded.

Is the problem documented anywhere ? Its strange that only Dat
Analysis ToolPak seems to have the problem. Other addins seems to b
working properly when opened in browser..

 

[Dave Peterson]

I've only seen it posted in the newsgroup--but I haven't searched the MSKB.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO