close

I have a ppt presentation that uses six different charts that I created in an
excel workbook. I want the charts in the ppt to update every time I enter
data into the excel worksheet but when I use the link function
quot;insert-gt;objectquot; it ends up putting the same chart on all the ppt slides
rather than the one slide it needs to be on. Any help is appreciated.

Insert Object From File inserts the active sheet at the time the file was
last saved, or the active sheet at the time the object was inserted, if it
is active in Excel at that time.

I would recommend that you copy the chart in Excel, then use Paste Special -
Link in PowerPoint.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Userquot; gt; wrote in message
...
gt;I have a ppt presentation that uses six different charts that I created in
gt;an
gt; excel workbook. I want the charts in the ppt to update every time I enter
gt; data into the excel worksheet but when I use the link function
gt; quot;insert-gt;objectquot; it ends up putting the same chart on all the ppt slides
gt; rather than the one slide it needs to be on. Any help is appreciated.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()