PowerPoint Tips Blog

Helping you with presenting, PowerPoint, and speaking

  • Home
  • Blog
  • Tips
  • E-Store
  • Training
  • About
  • Affiliates
  • Advertise
  • Contact
You are here: Home / Design / Animation & transitions / Insert a live Excel spreadsheet onto a slide

Insert a live Excel spreadsheet onto a slide

February 6, 2012 by Ellen Finkelstein 51 Comments

READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

You can insert a live Excel spreadsheet onto a slide so that you can use Excel while in Slide Show view.

There are other ways to get Excel data onto a slide, so why would you want an active Excel spreadsheet? Let’s say that you’re presenting some results of your financial analysis and your boss asks, “How did you get those results? Show me the spreadsheet.” You could switch to Excel, but it might be more slick to have it available in your PowerPoint presentation.

Slick? What does that mean? It just means that the process is less disruptive and more continuous, so it looks more professional. Try out this unusual technique and see if you like it.

Here are the steps:

  1. Choose Insert (tab)> Object> From File. In the Insert Object dialog box, choose the Create from File option.
  2. Click Browse, navigate to the Excel file, and double-click it. Click OK. You now see the spreadsheet on your slide. You may see all of it or part of it, but when you show it in Slide Show view, you’ll be able to pan and zoom to display what you want.
  3. In PowerPoint 2003, choose Slide Show> Custom Animation. In 2007 and 2010, go to the Animations tab. In 2007, click Custom Animation.
  4. With the spreadsheet selected, choose Add Effect in 2003 and 2007. Choose Add Animation in 2010. From the categories choose Object Actions or OLE Action Verbs. Then choose Edit or Open; it doesn’t seem to make any difference. Leave the default On Click setting, so that the animation happens when you click.
  5. When you go into slide show view, you’ll see the same thing you saw when you inserted the spreadsheet. Now click and the Excel spreadsheet will open. Depending on your version, the spreadsheet may be in front of your slide or you may simply switch to Excel. In either case, you can now do anything that you can do in Excel, including edit the data and use Excel’s tools.

What you’re seeing is a temporary view of your spreadsheet inside PowerPoint. See the highlighted text: “Worksheet in PowerPoint Slide Show.”

To go back to your slide show, just close the spreadsheet, using the X button.

Thanks to Echo Swinford for her expertise.

Share21
Tweet
Share1
+15
Shares 27
READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

Related posts:

  1. Link to a specific PowerPoint 2003, 2007 or 2010 slide from Microsoft Word or Excel
  2. Switch to another presentation seamlessly
  3. Where and how to insert an image
  4. View your slide show in a smaller window so you can see another presentation or program

Filed Under: Animation & transitions, Charts, tables & diagrams, Delivery

51
Leave a Reply

avatar
This comment form is under antispam protection
43 Comment threads
8 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
41 Comment authors
ClinqiueEspoirYuvarajMariam AbutalebPurchase Testosterone Online in UsaWindow washing gold coast Recent comment authors
avatar
This comment form is under antispam protection
  Subscribe  
newest oldest most voted
Notify of
Malcolm Guidry
Guest
Malcolm Guidry

Excellent tip, thank you! I occasionally must insert Excel sheets into PPT slides and have been doing so using a more primitive way. This is a much better alternative.

Vote Up0Vote Down 
11 years ago
Ellen
Guest
Ellen

Malcolm,
Other alternatives, such as embedding and linking, also have value. It depends on the circumstances.

Vote Up0Vote Down 
11 years ago
Nauman
Guest
Nauman

Thanks, It works great

Vote Up0Vote Down 
10 years ago
Lisa
Guest
Lisa

Do you know if you can use one spreasheet for all your slides or if you need to have one spreadsheet for each slide?
Thanks

Vote Up0Vote Down 
10 years ago
Ellen
Guest
Ellen

You can only insert a spreadsheet on one slide at a time. I guess you could insert it on each slide, but why would you do that? In other words, why go to a different slide to discuss the same spreadsheet?

Vote Up0Vote Down 
10 years ago
Lisa
Guest
Lisa

It would be very useful to have one spreadsheet for all the slides of a ppt so if you wish to modify the data you can be assured that the change will be consistent across the presentation.

Vote Up0Vote Down 
10 years ago
Aman
Guest
Aman

Hi

Thank you for this. Really helpful.

Following the instructions, I was able to click and open a PDF file in Slide show mode. But, I had to use alt-tab to move to the open PDF. Is there a way to make it open and get displayed as the active window?

Thank you so much! 🙂

Vote Up0Vote Down 
10 years ago
Anju
Guest
Anju

Thank you for this tip.
I got the perfect solution.

Vote Up0Vote Down 
10 years ago
Rayna
Guest
Rayna

The inserted icon of Excel Spreadsheet can’t open in Slide Show, but in PPT slides can. How can I open in Slide Show?

Vote Up0Vote Down 
10 years ago
Luca
Guest
Luca

Hi,

I’m copying an excel file into a powerpoint presentation and the tables are now linked to the excel.

The problem is that the fonts on the poworpoint are more condensed and not easy to be read. The original excel doesn’t have such a problem.

What can I do to solve this problem?

Thank you

Luca

Vote Up0Vote Down 
10 years ago
gavin
Guest
gavin

i had the same problem. i had a big spread sheet with a long list of rows and it was all condensed and unreadable.

Vote Up0Vote Down 
9 years ago
Vinoth
Guest
Vinoth

Thanks…

Vote Up0Vote Down 
9 years ago
Gaunkar
Guest
Gaunkar

thanks 🙂

Vote Up0Vote Down 
9 years ago
kaustubh
Guest
kaustubh

I have inserted the worksheet in my ppt but the data inserted does not get updated in the original sheet. And I also cannot use the edited worksheet from the first slide in the further slides. Is there a way to do that?

Vote Up0Vote Down 
9 years ago
Dan
Guest
Dan

Many thanks for this tip. It’s brilliant (once I had realised that in my version of PowerPoint 2007 it’s got nothing to do with “Slide Show” or “Custom Animation” – the final “Object Actions” step is implemented from the “Action” command that is in the “Links” section of the “Insert” menu bar). I found that, in the last step of your sequence of steps, an alternative way of linking the slide to the live spreadsheet is to insert a hyperlink from the slide to the spreadsheet. This has an advantage in certain circumstances(see below). To do this use the “Hyperlink”… Read more »

Vote Up0Vote Down 
8 years ago
Chad
Guest
Chad

I used the NOW() function in the spreadsheet I embedded into the powerpoint. The powerpoint runs in a loop to display information to my group. The function is not updating automatically when the days change. Is there a way to have the spreadsheet update on every pass through the ppt show?

Vote Up0Vote Down 
8 years ago
Manish
Guest
Manish

Hellow…. Thank U for this tip..
Awesome.. ur a star.. 🙂

Vote Up0Vote Down 
8 years ago
VIKRAM
Guest
VIKRAM

YES IT IS EXTREMELY HELPFUL BOSS

Vote Up0Vote Down 
8 years ago
Mayo
Guest
Mayo

I got this, but the spreadsheet is not active once I move from normal view to slide show. I cant open the spreadsheet to update data in powerpoint in d slideshow view. Any tips?

Vote Up0Vote Down 
8 years ago
Chris
Guest
Chris

Is there any way to have it auto-update, so I can change the data and not need exit and re-run the ppt?

Vote Up0Vote Down 
8 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

Instead of going to a live Excel spreadsheet, you can insert the chart into PowerPoint and link it. See these YouTube videos that I created:
http://youtu.be/c38jOo399Wk
http://youtu.be/LSHUT4L5vI0

Vote Up0Vote Down 
8 years ago
jameei
Guest
jameei

Hi. I have a problem in powerpoint : I want to insert an excel file to one slide so when I open the slide , powerpoint open the excel sheet . in other word I want to hyperlink an excel file/extracted sheet in a powerpoint slide . please help me. thanks

Vote Up0Vote Down 
8 years ago
john
Guest
john

Really neat way

Vote Up0Vote Down 
8 years ago
Seth
Guest
Seth

How do you link a large excel spreadsheet into multiple powerpoint slides? The excel document I am trying to link has hundreds of rows, so it won’t all fit on one powerpoint slide… any suggestions?

Vote Up0Vote Down 
8 years ago
Janice
Guest
Janice

This works perfect; however, I’m using 2013 and the Excel opens favoring the bottom of slide…it doesn’t open in the center. Any work around?

Vote Up0Vote Down 
8 years ago
Shambhavi
Guest
Shambhavi

I have inserted the worksheet in my ppt but the data inserted does not get updated in the original sheet. And I also cannot use the edited worksheet from the first slide in the further slides. Is there a way to do that?

Vote Up0Vote Down 
8 years ago
Neeraj
Guest
Neeraj

If we have more than one sheet in an excel file and we want all the sheets to get inserted into powerpoint, ofcourse in different slides, how can we do so??

Vote Up0Vote Down 
8 years ago
avi
Guest
avi

Or…use EzPaste (www.excel-premiumutilities.com) for completely automating the transfer from Excel to PowerPoint (hundreds of charts and tables in one click)

Vote Up0Vote Down 
8 years ago
Tanit
Guest
Tanit

It’s just perfect, thank you so much!

Vote Up0Vote Down 
8 years ago
Henry L. Alexander
Guest
Henry L. Alexander

Hi Ellen, Thank you very much. I use this technique often. One recurring problem I have (more of an annoyance than a problem). My worksheet almost always (not always) comes in occupying about half of the available screen. I want it to open in full screen mode. My original is full screen. I have made sure that it is saved in full screen. The spreadsheet is displayed t the correct size but it is not fully visible because the window is not full screen. Any help would be appreciated ad would make a really great tool into an indispensable tool.

Vote Up0Vote Down 
7 years ago
tarun singh
Guest
tarun singh

thanks u so much…it is very useful info

Vote Up0Vote Down 
7 years ago
petr s
Guest
petr s

You can also fine tune the opening of spreadsheet or else in Powerpoint 2016 by option TRIGGER->ON CLICK->specific OBJECT which means that during presentation after pointing the inserted file the cursor changes to hand so you can return to or reopen any file in the slide show.

Vote Up0Vote Down 
7 years ago
Wilfried
Guest
Wilfried

Ever tried this on a Mac?

Vote Up0Vote Down 
7 years ago
Franco
Guest
Franco

Just tried exactly that, but can’t get it to work, which is how I stumbled on this thread. I am using Office for Mac 2016 and struggle finding “Object Actions”. Any help appreciated!

Vote Up0Vote Down 
7 years ago
Teacher Reed
Guest
Teacher Reed

I have created a interactive excel where a picture is in the background and items in the picture are identified by using the comments. It works great but now I want to insert this interactive excel on a slide in PPT. I can get the picture to insert and the excel document but the comments will not move and work. Is there a way to do this?

Vote Up0Vote Down 
6 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

I can’t really picture what you’re doing and how the comments work, but there is a Comments feature in PowerPoint.

Vote Up1Vote Down 
6 years ago
Teacher Reed
Guest
Teacher Reed

First of all I am a computer teacher. When teaching my students how to use comments in Excel we made a interactive map. We placed a map in the background of excel of a state. Then we grouped several cells around major cities. To teach them how to use comments I had them research those cities quickly and locate a tourist attraction. They typed the name and placed a picture of the attraction in the comment box. Now we are on PowerPoint and are getting ready for our final which is creating everything needed for a travel agency grand opening,… Read more »

Vote Up1Vote Down 
6 years ago
Eytan
Guest
Eytan

HI – Is there any way to embed an excel sheet in a PPP which is the summary of a larger data sheet, in a way that clicking that summary will bring up the full excel sheet it’s been cut from? And if this is not complicated enough, here’s the real question – is there a way to embed the excel sheet that when I send the whole presentation to someone else I won’t have to send the excel sheet as a separate file? Creating a hyperlink doesn’t not work because once the presentation is sent out of the original… Read more »

Vote Up0Vote Down 
6 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

One of these techniques might help you: https://www.youtube.com/playlist?list=PLK8S9AUrwAmjjUExkhkCZMF5bf6yXmtKH

Vote Up0Vote Down 
6 years ago
Sara
Guest
Sara

Hi- I have been able to link my excel spreadsheets to my powerpoint. However, I am having an issue with saving. Each month, I want to save the prior months data, and then do a save as for the new month and have the new (saved as “new month” excel and powerpoint be reflective of the new month and not be linked to the original (previous) excel file, which mine is currently doing. How can I accomplish this?

Vote Up0Vote Down 
6 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

Sara, can you do it the other way around? In other words, do a Save As but then go back to the original spreadsheet and update that one. In that way, the updated spreadsheet always has the same file name and location. Think of your Save As as a way of archiving old spreadsheets instead of creating updated ones.

Vote Up0Vote Down 
6 years ago
Somendra Mishra
Guest
Somendra Mishra

Dear all
when i hyperlink presentation to excel spreadsheet. but i found that only one sheet linked in this file and i want to hyperlink one slide to many more sheets. Please help me.

Vote Up0Vote Down 
6 years ago
Brooke
Guest
Brooke

Hi Ellen,
I’m trying to take multiple data spreadsheets in a multi-sheet excel file (each sheet has a different spreadsheet on it) and put it into my powerpoint presentation. However, I want each spreadsheet to reflect the changes I make in excel file on the powerpoint. Hyperlinking hasn’t worked for me because there are multiple spreadsheets in the excel file. I tried to rename the data I wanted to use by using the ‘Define Name’ function then go about inserting it into my powerpoint that way, but it isn’t working. Is there an alternative method?

Thanks!

Vote Up0Vote Down 
6 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

Brooke, it would take me quite a while to check this out and I’d probably have to use your files, but this might help:
http://www.ellenfinkelstein.com/pptblog/hyperlink-to-a-specific-slide-in-another-presentation-or-specific-location-in-another-file/. I’m pretty sure you can hyperlink to a specific worksheet within a workbook, but haven’t done that in a while. Is there some reason you can’t divide up the content onto multiple slides?

Vote Up0Vote Down 
6 years ago
trackback
How To Create Animation In Excel 2003 | Try new animation software

[…] Insert a live Excel spreadsheet onto a slide – You can insert a live Excel spreadsheet onto a slide so … Add Effect in 2003 and 2007. Choose Add Animation in 2010. From the categories choose Object Actions or OLE Action Verbs. Then choose Edit or Open; it doesn’t seem to make … […]

Vote Up0Vote Down 
6 years ago
Window washing gold coast
Guest
Window washing gold coast

Thank you so much! a really valuable internet site; couldn’t make it without ya!

Vote Up0Vote Down 
5 years ago
Purchase Testosterone Online in Usa
Guest
Purchase Testosterone Online in Usa

Thanks a ton. a really beneficial article; could not make it without
ya!

Vote Up0Vote Down 
5 years ago
Mariam Abutaleb
Guest
Mariam Abutaleb

Hello,

I was wondering if by using excel live in my presentation, when i edit some numbers in it, will it automatically update the charts in PowerPoint as well? (charts are linked to the excel file too)

Vote Up0Vote Down 
5 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

Yes, you’ll be viewing an Excel spreadsheet, so whatever is on the Excel spreadsheet, you’ll see. But there are other ways to update data in PowerPoint. These might help:
http://www.ellenfinkelstein.com/pptblog/link-text-to-an-excel-cell-dynamically-update-data/
https://www.youtube.com/watch?v=LSHUT4L5vI0&feature=youtu.be
https://www.youtube.com/watch?v=c38jOo399Wk&feature=youtu.be
http://www.ellenfinkelstein.com/pptblog/how-to-create-a-chart-graph-in-powerpoint-from-excel-data-part-iii/

Ellen

Vote Up0Vote Down 
5 years ago
Yuvaraj
Guest
Yuvaraj

Hi,

I want to have the table from excel file as editable table while presenting the slide instead of excel opening in front of slide show. In this way, I can apply data for calculation for the formulas present already.

Yuvaraj

Vote Up0Vote Down 
3 years ago
wpdiscuz   wpDiscuz

Free Video Training!

13 Techniques that Will Make Designing Your Slides EASY!

And get the PowerPoint Tips Newsletter with tips and resources for presenters. Plus 5 bonus tips!

BirdSend Email Marketing Tool
4-up-ads PresenterMedia PoweredTemplate High-Persuasion Secrets Power Pointers Quarter Hour


Recent Posts

Recent Posts

  • Using PowerPoint’s cartoon people
  • Which version of PowerPoint should you buy?
  • Add a customizable, live web feed with Cameo
  • Get a designer look with abstract images to create backgrounds for slides and shapes
  • Creating and using a strong call-to-action slide

Connect with me!

Connect with me! Twitter LinkedIn Facebook

Ellen Finkelstein, Inc. · Fairfield, IA · Tel: 515-989-1832

Privacy, Refund, and Other Legal Stuff

wpDiscuz