Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Location
    Spring Lake, Michigan, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to save embedded excel information (Powerpoint 2000)

    Hello,

    I received a powerpoint presentation with several excel chart objects embedded in a slide. I wish to access the data behind the chart, and then save it as a separate workbook file for further analysis in excel. When I click on the object, or expand it, I can eventually see worksheet tabs and all the data. But I'm stuck playing with it in powerpoint.

    How does one transfer/transform the embedded excel chart/worksheet object back into its native excel workbook?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to save embedded excel information (Powerpoint 2000)

    Hi Joel
    On my system (W2K and PP2K), when the PP object has been embedded as an MS Excel Worksheet, I can right click on it, select Worksheet Object and then Open.
    This opens Excel (even if it is not already running) and puts the data into a standard Excel worksheet. This then allows me to 'Save Copy As' and creates a normal, Excel file.
    Hope this works for you.
    Cheers
    Silverback

  3. #3
    New Lounger
    Join Date
    Nov 2002
    Location
    Spring Lake, Michigan, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to save embedded excel information (Powerpoint 2000)

    You da Alpha Male silverback!

    When I right click on the chart the open command is hidden on a submenu, but it does open the excel workbook containing the data for the chart. Once there I was able to save it because now Excel was open instead of Powerpoint. One oddity remained. Excel suggested the filename XXX.ppt for the new workbook, even when the filetype of workbook was selected from the drop down list. Weird. When I saved it with that name, and re opened it, it launched powerpoint and what a mess! But your idea was right, and changing the extension took care of the second problem.

    Have a bunch of bananas on me! <img src=/S/munch.gif border=0 alt=munch width=19 height=17>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •