Hello. PowerPoint 2013.
I copied some Excel data and pasted it as a link into the Edit Data box, but when I close and open PowerPoint it still has the old values. Where is the simple option to update the data please? (This shouldn't be so hard!!)
Where is the option to update Excel data?
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Where is the option to update Excel data?
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Where is the option to update Excel data?
Is your link setting possible set on manual update?agibsonsw wrote:Hello. PowerPoint 2013.
I copied some Excel data and pasted it as a link into the Edit Data box, but when I close and open PowerPoint it still has the old values. Where is the simple option to update the data please? (This shouldn't be so hard!!)
If you go to the FILE ribbon, INFO tab, bottom right corner, click on Edit Links and check on the dialog if the option is manual or automatic.
Usually links will prompt when you open the presentation. You can also manually update if you click on the linked object, and and choose update links on the contextual ribbon of that object.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Where is the option to update Excel data?
Hi Rudi.
Unfortunately, there is no "Edit Links" option in the properties, or advanced properties. I can find no similar options in either of the contextual tabs, and the various Edit options lead me nowhere
Unfortunately, there is no "Edit Links" option in the properties, or advanced properties. I can find no similar options in either of the contextual tabs, and the various Edit options lead me nowhere
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Where is the option to update Excel data?
Hi Andy,
Here are some screenshots of the edit links and the auto update options.
With charts for example, you have a button called Refresh Data
BTW: What happens if you right click and view the menu...is there update link options there?
Here are some screenshots of the edit links and the auto update options.
With charts for example, you have a button called Refresh Data
BTW: What happens if you right click and view the menu...is there update link options there?
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Where is the option to update Excel data?
When I close this PPT and reopen it it prompts to update all the links...as in this image...
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Where is the option to update Excel data?
This is my fault, sorry. I've created a Chart in PowerPoint, and pasted linked data into the Edit Data window.
That is, I'm not directly linking to either a worksheet or chart. None of the screenshot image-options appear for me.
That is, I'm not directly linking to either a worksheet or chart. None of the screenshot image-options appear for me.
You do not have the required permissions to view the files attached to this post.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Where is the option to update Excel data?
Hi Andy,
I see your point - the refresh and update buttons are disabled.
However, I notice that the linked data does update if you use the dropdown and point to Edit data in Excel 2013 (not just the Edit Data option - here it does NOT update).
The moment the Excel window activates, the linked data is updated and reflected on the chart. (You can actually see the links to the source workbook in the formula bar.
I see your point - the refresh and update buttons are disabled.
However, I notice that the linked data does update if you use the dropdown and point to Edit data in Excel 2013 (not just the Edit Data option - here it does NOT update).
The moment the Excel window activates, the linked data is updated and reflected on the chart. (You can actually see the links to the source workbook in the formula bar.
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Where is the option to update Excel data?
Still no joy for me. Even if I Edit Data in Excel and then (from Excel) go to the Data tab and choose Edit Links, Update, it all drops to #REF
Maybe having more than one version of Office on my computer doesn't help? But a colleague tried on another computer and had similar issues.
Maybe having more than one version of Office on my computer doesn't help? But a colleague tried on another computer and had similar issues.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Where is the option to update Excel data?
Is it absolutely necessary to go the route of pasting the data from Excel into the Edit Box of PowerPoint?agibsonsw wrote:Still no joy for me. Even if I Edit Data in Excel and then (from Excel) go to the Data tab and choose Edit Links, Update, it all drops to #REF
Maybe having more than one version of Office on my computer doesn't help? But a colleague tried on another computer and had similar issues.
Could you not simply draw up the graph in Excel, then copy and paste the graph into PowerPoint. This is a more common way of doing it (and IMHO, a much better way) and I'm sure this method will not give you any issues when it comes to updating the links.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Where is the option to update Excel data?
This is the route I've generally recommended, rather than people just copying and pasting an Excel chart. The Excel chart they have might be too detailed for PowerPoint, used to cause distortion issues and requires the chart to remain in the spreadsheet.
But it looks like we have no choice now. I am not enamoured of 2013. A lot of things that were previously easy are now either hard or not possible. For instance, if I save a presentation as a template it doesn't appear on the front page, it only shows MS, online templates. And I can't see anywhere to turn off the silly animation effects (of the UI).
Thank you for your assistance though. Andy.
But it looks like we have no choice now. I am not enamoured of 2013. A lot of things that were previously easy are now either hard or not possible. For instance, if I save a presentation as a template it doesn't appear on the front page, it only shows MS, online templates. And I can't see anywhere to turn off the silly animation effects (of the UI).
Thank you for your assistance though. Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- 2StarLounger
- Posts: 170
- Joined: 05 Feb 2010, 18:04
- Location: Jacksonville, NC
Re: Where is the option to update Excel data?
I use the Insert Object command in any version of PowerPoint, and have no trouble linking to an Excel Chart or spreadsheet.
1. On a slide in PowerPoint (Title Slide for example) choose the Insert Ribbon
2. Choose the Object command
3. Choose the From File command, and find your file, ensure the checkbox for Link is chosen and choose the OK command button.
4. You will double-click on the object to refresh the file as it is a direct link to Excel. If you change it in Excel and save, it changes in PowerPoint.
Maybe I'm missing something here. If so, clue me.
1. On a slide in PowerPoint (Title Slide for example) choose the Insert Ribbon
2. Choose the Object command
3. Choose the From File command, and find your file, ensure the checkbox for Link is chosen and choose the OK command button.
4. You will double-click on the object to refresh the file as it is a direct link to Excel. If you change it in Excel and save, it changes in PowerPoint.
Maybe I'm missing something here. If so, clue me.
You do not have the required permissions to view the files attached to this post.
If you can't convince them, confuse them - Harry S. Truman
Nannette
Nannette
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: Where is the option to update Excel data?
Hello teachesms. I know this option but it isn't what I wanted. I wanted to link to the Excel data, but build the chart in PowerPoint. I've always done this previously by copying, and linking, the Excel data into a PowerPoint-Chart's Datasheet (now the Edit Data dialog in 2013). It seems that this is no longer an option sadly.
But thanks for your response ;)
But thanks for your response ;)
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.