[Solved] Embedded Excel in PowerPoint Not Showing All Data

We can insert the data from Excel into PowerPoint in different ways. Embedding an Excel file into a PowerPoint is one of them. The Embedded file does link the original Excel file with the file of PowerPoint file. A copy of the Excel file is attached to the PowerPoint. But sometimes it is seen that all data of the embedded Excel file does not appear in the PowerPoint. In this article, we will discuss this problem and its solution with proper illustrations.

Embedded vs Other Inserted Excel Files in PowerPoint: What Are the Differences?

Embedding and linking any Excel into a PowerPoint is not the same. Have a look at some differences in the below section.

When any Excel file is embedded, that will not update automatically with the modification of the Excel file. But in the case of the linking, the file will update in the PowerPoint for any kind of modification.
In the case of embedding, we cannot edit the Excel file from PowerPoint. But in linking, we will be able to edit the Excel file by clicking the file of PowerPoint.
When we send any PowerPoint file where an Excel file is Embedded, we do not need to send the original Excel file. But in the case of linking, we must send the original Excel file.

How to Solve When Embedded Excel in PowerPoint Is Not Showing All Data

Now, let’s see how to embed any Excel file into PowerPoint with detailed steps first. This is the dataset of the Excel file. We will want to embed this into PowerPoint.

First, open a PowerPoint file.
Go to the Insert tab.
Choose the Object option from the Text field.

The Insert Object window appears.
Choose the Create from file option.
Then, click on the Browse option.

Now, select the desired Excel file from File Explorer.
Then, click on the OK button two times.

Look at the PowerPoint window.

We can see the dataset is showing here.

Now, when we embed any Excel file of a big size, sometimes all data do not show. It means data partially appears in the PowerPoint. For example, this is our Excel dataset that needs to embed into the PowerPoint file.

📌 Solution:

Embed the Excel file as shown before.

Look at the PowerPoint file. All the data are not showing. Some have been removed or not appear for an unknown reason. Now, we have to solve this.

Go to the Excel sheet.
Select the whole dataset and copy that by pressing Ctrl+C.

Then, go to the PowerPoint window.
Click on the down arrow of the Paste option from the Home tab.
Choose Embed (E) from the Paste Options section.

Again, look at the dataset. We can see all data are showing.

How to Insert an Excel File into PowerPoint as an Icon: Alternative to Embedding Files

There is an option to insert an Excel file into a PowerPoint and present that as an Excel icon instead of presenting the real data set in the PowerPoint.

📌 Steps:

Enter the PowerPoint file.
Choose the Object of the Text field from the Insert tab.

The Insert Object window appears.
Choose the desired Excel file from File Explorer by pressing the Browse button.
Then, mark the Display as icon option.

Finally, press the OK button and look at the dataset.

We can see an icon for the embedded Excel file. If we click on the icon, the Excel file will appear.

How to Embed an Excel Chart into PowerPoint

In this section, we will show how to insert or embed a chart into PowerPoint.

📌 Steps:

First, we will create a new chart in Excel. Select the dataset.
Then, go to the Insert tab.
After that, select a chart from the Chart group.

Look at the dataset.

We can see a chart has been created. We want to embed this chart into PowerPoint.

First, select the chart and copy that by pressing Ctrl +C.
Then, go to the PowerPoint window.
Choose Paste Special from the Paste field.

The Paste Special window appears.
Mark the Paste option.
Then, choose the type from this given box.

Finally, press the OK button and look at the PowerPoint window.

The chart has been embedded in PowerPoint from Excel.

Conclusion

In this article, we described how to embed Excel into PowerPoint, and solve the problem of all data not showing from embedded Excel. We also showed how to embed charts from Excel to PowerPoint and show Excel as an icon. I hope this will satisfy your needs. Please, give your suggestions in the comment box.

<< Go Back to Excel to PowerPoint | Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!