Linking from excel to PPT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My biggest issue is that I will have multiple charts to have in PP that will
link back to the master spreadsheet in excel. I want to have a seperate slide
for each line of data. There will be approximatly 45-60 slides. I want one
master spreadsheet to input my info into and have it automatically update in
each PP chart. Does that make sence? Is that possible?
Thank you so much!
 
Lori,

This should work.

Copy each chart and paste into PPT where you'd like it. However, don't just
click paste - click Edit-Paste Special and choose Paste Link.

Now when you change your spreadsheet data, the next time you open PPT it
will prompt to refresh from linke files.

Also, be sure not to move or rename the files as that would most likely
break the links.

hth
 
Gary,

While waiting for you to come to my rescue I was playing around and I did
it! Yahoo! Thank you so much for replying to my post! It helps to validate
what I figured out and it's nice to kow this posting stuff works!
 
Your welcome, Lori.

Lori C said:
Gary,

While waiting for you to come to my rescue I was playing around and I did
it! Yahoo! Thank you so much for replying to my post! It helps to validate
what I figured out and it's nice to kow this posting stuff works!
Click to expand...
 
this is great. but when i edit it, even a simple open and close, it reformats
in ppt, extends the height, gridlines come on, and looks like a completely
diff excel file... any way to stop this?
 
Back
Top