Cannot use Data Analysis tools on Excel worksheet embedded in PwrP

[Guest]

When I cut and paste Excel Worksheet Object into PowerPoint, the object has
much, but not all the functionality of an Excel worksheet. I need to use the
Data Analysis tools and they don't work. (They are, of course, installed.)

I can double-click on the embedded Excel file and cut and paste into an
blank Excel and use the Data Analysis Tools but that's not as neat.

I use PowerPoint to teach Excel, and this behavior is hurting. The
computer(s) I used a year ago did not have this problem, by all of my Windows
XP/Office 2003 machines behave the same way.

 

[Steve Rindsberg]

When I cut and paste Excel Worksheet Object into PowerPoint, the object has
much, but not all the functionality of an Excel worksheet. I need to use the
Data Analysis tools and they don't work. (They are, of course, installed.)

I can double-click on the embedded Excel file and cut and paste into an
blank Excel and use the Data Analysis Tools but that's not as neat.

I use PowerPoint to teach Excel, and this behavior is hurting. The
computer(s) I used a year ago did not have this problem, by all of my Windows
XP/Office 2003 machines behave the same way.

I'm not positive, never having used this feature, but it sounds like another
outgrowth (excresence one might say, if one could spell it properly) of Office
2003's preoccupation with security.

It's trying to protect you from potential Bad Guys, but sometimes that turns out
to be harmless li'l ol' you trying to run your own perfectly safe stuff on your
own computer, and protecting you doees more harm than good. In this case.

What happens if you link to an external XLS file using an Action Setting? That
will launch the file in Excel rather than launching it for in-place editing
within PPT. The behavior might then be different.

Another thing you might try:

Rightclick the Excel content, choose Action Settings from the pop-up menu.
Object Action is probably set to Edit. Try changing it to Open.