Linked table from excel

  • Thread starter Thread starter Calvin
  • Start date Start date
C

Calvin

I am using Excel 2003. I have multiple data tables in excel on one
worksheet that are each linked to a different page of a powerpoint
2003 presentation. Now, when I do any editing to the worksheet such
as adding another data row into one of the table, thus shifting
everything below it down, the linked tables are all shifted down. Is
there a way to keep linked tables to powerpoint, but have the program
follow the shifted data, and allow me to add/delete rows? Much
appreciation if anyone can tackle this.
 
I am using Excel 2003. I have multiple data tables in excel on one
worksheet that are each linked to a different page of a powerpoint
2003 presentation. Now, when I do any editing to the worksheet such
as adding another data row into one of the table, thus shifting
everything below it down, the linked tables are all shifted down. Is
there a way to keep linked tables to powerpoint, but have the program
follow the shifted data, and allow me to add/delete rows? Much
appreciation if anyone can tackle this.
Click to expand...

Great question! In poking at this I learned that if you select your data and
insert, name, define (ie, name the range), then copy and paste-special, link to
PPT, it seems to do exactly what you want.

The link is to the named range rather than to a specific range of cells.


--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
Back
Top