View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SRG
 
Posts: n/a
Default Cannot use Data Analysis tools on Excel worksheet embedded in PwrP

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.