View Single Post
 
Old 06-25-2019, 02:11 AM
dcmontva dcmontva is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2019
Location: UK
Posts: 9
dcmontva is on a distinguished road
Smile Pasting linked data from excel into PowerPoint

Hi all.
I am trying to copy data from an excel table into a PowerPoint presentation table, but no matter which procedure I choose accomplish this task, the data doesn't update, and strangely i don't see the "edit link" facility on the info page. This is the main procedure I follow.

* Open PowerPoint and add new slide
* Insert column chart (example excel worksheet opens)
* Delete example data and paste data from my excel worksheet into PowerPoint table cells using 'past link (N)'. The chart immediately updates ok. I save the PowerPoint slide and close down the external excel file. Both files are saved together in the same folder.
* I open excel file and change some data and save.
* I open PowerPoint file but the chart hasn't updated and the 'refresh chart' button is unavailable, as is the 'edit data' button. Also, when I go to the info page and look for 'edit link' facility it is not there. So that must mean it is not saving the the data I have pasted as linked data.

If I create a chart in excel with the original table and then paste the chart into PowerPoint it works fine and updates every-time!

What gives?

Many thanks in advance!
Reply With Quote