How To Edit A Worksheet Object in a PowerPoint 365 Slide

As we already know, we can use an Excel Chart or Excel Table Data that we created in a PowerPoint Slide. We just simply copy it from Excel and then use the Paste Options to paste into the PowerPoint Slide. This way, the Data is linked between the Excel Worksheet and the PowerPoint Slide. When we want to change or edit the Data or the Chart from the PowerPoint Slide we have several options available in order for us to use. All you need to do is to continue reading the post below.

How To Edit A Worksheet Object in PowerPoint 365

In the image below, I have inserted a Chart that I have created in Excel in a PowerPoint Slide. With the Chart, we can also see the table that contains all the Data that was used to create it.

Selected Chart in PowerPoint

In the following image, I have selected the area of the Object, by just clicking on it and then I right clicked on it for the shortcut menu to appear. Once the shortcut menu appears, we located the command that mentions Worksheet Object. When the Worksheet Object command is selected, the sub-menu appears which contains three commands, and which are the following:

  • Edit: By using this command, Microsoft Excel will open containing our Data and Chart where we can Edit them.
  • Open: By using this command, Microsoft Excel will open containing our Data and Chart, where once again we can Edit and Modify them.
  • Convert: By using this command, we will be able to Convert or Activate our Worksheet in a variety of types.

Right Click - Worksheet Object

In the image below, I have right clicked on the Object in the PowerPoint Slide and from the shortcut menu that appeared I selected the command Worksheet Object, and then from the sub-menu I have selected the command Edit.

Worksheet Object - Open

Once the Edit command is selected, the Worksheet Object is activated, and Microsoft Excel opens, where the Worksheet that contains our Data and Chart appears among with all the available commands. Now, we can Edit the Data or Chart and once we are finished, all we need to do is to just click outside the Worksheet Area so we can return to our PowerPoint Slide, and all the changes that we made will take place.

Opened Worksheet

In the image below, I have right clicked on the Object in the PowerPoint Slide and from the shortcut menu that appeared I selected the command Worksheet Object, and then from the sub-menu I have selected the command Open.

Worksheet Object - Edit

Once the Open command is selected, the Worksheet Object is activated, and Microsoft Excel opens, where the Worksheet that contains our Data and Chart appears among with all the available commands.

Open in Microsoft Excel

In the image below, I have right clicked on the Object in the PowerPoint Slide and from the shortcut menu that appeared I selected the command Worksheet Object, and then from the sub-menu I have selected the command Convert.

Worksheet Object - Convert

Once the Convert command is selected, the Convert dialog box appears where we have to available commands:

Convert Worksheet

Convert To: If we select this command, then we can select either to convert the Worksheet Object to one of the following:

  • Microsoft Excel 97-2003 Worksheet
  • Microsoft Excel Binary Worksheet
  • Microsoft Excel Macro-Enabled Worksheet
  • Microsoft Excel Worksheet
  • OpenDocument Worksheet

Activate As:

  • Microsoft Excel 97-2003 Worksheet
  • Microsoft Excel Binary Worksheet
  • Microsoft Excel Macro-Enabled Worksheet
  • OpenDocument Worksheet

This way, the Data is linked between the Excel Worksheet and the PowerPoint Slide. When we want to change or edit the Data or the Chart from the PowerPoint Slide we have several options available in order for us to use

So, there is no reason to worry about, moving between the Excel Worksheet and the PowerPoint Slide so we can change the Data or the Chart. We can do all the editing and changes we need straight through in our Slide and PowerPoint will take care of the rest.

Below you can check out the video describing How To Edit A Worksheet Object in a PowerPoint 365 Slide.

Don’t Forget To Subscribe To My YouTube Channel.

YouTube Channel

Advertisements

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on November 26, 2018, in Microsoft Office 365 ProPlus English, PowerPoint 365 English and tagged , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on How To Edit A Worksheet Object in a PowerPoint 365 Slide.

Comments are closed.