Hi,

I am trying to link an excel table into powerpoint, but in such a way that
would allow me to insert rows into the excel table, and still keep the row
that was last before the new row was inserted visible in the PowerPoint as
well.

I have tried pasting a link to the worksheet, and that works well, until I
need to insert a row (the last row - which is the total and most important -
just falls out of the table in powerpoint).

Thanks a lot in advance for you help!

In article <8B74C138-5FD4-480C-A881-A26791464EF2@microsoft.com>, Makaron wrote:
> Hi,
>
> I am trying to link an excel table into powerpoint, but in such a way that
> would allow me to insert rows into the excel table, and still keep the row
> that was last before the new row was inserted visible in the PowerPoint as
> well.
>
> I have tried pasting a link to the worksheet, and that works well, until I
> need to insert a row (the last row - which is the total and most important -
> just falls out of the table in powerpoint).

You're *almost* there.

Select the information you want to link in Excel
Choose Insert, Name, Define and give it a name that makes sense to you.
Now copy/paste special/link it to PowerPoint.



-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
www.pptlive.com

Thanks a lot!
It's always those tiny details that you end up spending so much time
figuring out!...
So, I really appreciate it.

"Steve Rindsberg" wrote:

> In article <8B74C138-5FD4-480C-A881-A26791464EF2@microsoft.com>, Makaron wrote:
> > Hi,
> >
> > I am trying to link an excel table into powerpoint, but in such a way that
> > would allow me to insert rows into the excel table, and still keep the row
> > that was last before the new row was inserted visible in the PowerPoint as
> > well.
> >
> > I have tried pasting a link to the worksheet, and that works well, until I
> > need to insert a row (the last row - which is the total and most important -
> > just falls out of the table in powerpoint).
>
> You're *almost* there.
>
> Select the information you want to link in Excel
> Choose Insert, Name, Define and give it a name that makes sense to you.
> Now copy/paste special/link it to PowerPoint.
>
>
>
> -----------------------------------------
> Steve Rindsberg, PPT MVP
> PPT FAQ: www.pptfaq.com
> PPTools: www.pptools.com
> ================================================
> Live and in personable in the Help Center at PowerPoint Live
> Sept 21-24, San Diego CA, USA
> www.pptlive.com
>
>

In article <470C2795-EAA1-49E4-82EF-065678B522F1@microsoft.com>, Makaron wrote:
> Thanks a lot!
> It's always those tiny details that you end up spending so much time
> figuring out!...
> So, I really appreciate it.

My pleasure ... actually, it was just a hunch on my part. You gave me an excuse to
try it out, so thanks back to ya. We both learned something.

>
> "Steve Rindsberg" wrote:
>
> > In article <8B74C138-5FD4-480C-A881-A26791464EF2@microsoft.com>, Makaron wrote:
> > > Hi,
> > >
> > > I am trying to link an excel table into powerpoint, but in such a way that
> > > would allow me to insert rows into the excel table, and still keep the row
> > > that was last before the new row was inserted visible in the PowerPoint as
> > > well.
> > >
> > > I have tried pasting a link to the worksheet, and that works well, until I
> > > need to insert a row (the last row - which is the total and most important -
> > > just falls out of the table in powerpoint).
> >
> > You're *almost* there.
> >
> > Select the information you want to link in Excel
> > Choose Insert, Name, Define and give it a name that makes sense to you.
> > Now copy/paste special/link it to PowerPoint.
> >
> >
> >
> > -----------------------------------------
> > Steve Rindsberg, PPT MVP
> > PPT FAQ: www.pptfaq.com
> > PPTools: www.pptools.com
> > ================================================
> > Live and in personable in the Help Center at PowerPoint Live
> > Sept 21-24, San Diego CA, USA
> > www.pptlive.com
> >
> >
>

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
www.pptlive.com