Insert Excel to Powerpoint....sounds easy....

[mishbaker]

I would like to have a power point slideshow based on one of my excel worksheets. My goal is to have each page (defined by pagebreaks) of my worksheet dynamically update a slide in the powerpoint presentation. Sure I can insert a worksheet onto a slide but the worksheet is so long that I would have to do this for each page in the worksheet every week. (The worksheet is like 15 pages long)

I'm not very familiar with powerpoint and was hoping there is a way to do this without having to code my way around it. If there isnt, and I have to write code, any suggestions on how to approach it?

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[SkipVought]

When you PASTE in power Point, select paste Special and paste a worksheet object -- PASTE LINK

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[mishbaker]

Is there a way to edit the links manually? It has the menu under EDIT -> LINKS... which allows you to update and such but I'd like to be able to change the link range if need be without having to reselect the object on each page of the presentation.


Thanks again for your help!

All lessons learned from the School of Hard Knocks........at least tuition is cheap.