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

--
Message posted from http://www.ExcelForum.com

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 <" wrote:

Hi All,

I opened an excel workbook in internet explorer. Then i selected the
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 my
surprise on selecting "Data Analysis", nothing happens. No dialog gets
opened.

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

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

Regards
Rosh

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

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..

--
Message posted from http://www.ExcelForum.com

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

http://support.microsoft.com/default...;EN-US;KBHOWTO

"rosh <" wrote:

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

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

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson