Solved

Excel OLE within PowerPoint

Posted on 2011-03-02
10
1,223 Views
Last Modified: 2013-11-17
I would like to imbed excel spreadsheet data into a powerpoint presentation - 4 different views of a single sheet (different columns) onto 4 different slides of a powerpoint (1 view per slide).  I would further want to have formulas defined in the active sheet which link the views, so that data entered in one view will activate the associated formula, and update a cell (which is part of a view on another slide).  I would then want that new data to be visible on the other pp slide.

Is this possible to do with OLE?  And if so HOW?  Or is it necessary to handle it via VBScript macro?

0
Comment
Question by:IcelanderLight
  • 4
  • 4
10 Comments
 
LVL 3

Expert Comment

by:saranyannarayanan
ID: 35023385
Use paste Special in power point and paste as excel worksheet , I believe this will solve the issue
0
 

Author Comment

by:IcelanderLight
ID: 35023581
Thank you Saranyannarayanan - I don't think this will do what I want.  I wish to go through the presentation, see on one slide part of my spreadsheet, enter some data into it, proceed to new slide, see another part of spreadsheet with new data created as a result of previous data entry and application of formula.  

When I use Paste Special I get the spreadsheet into the powerpoint, ad I can update individual cells, but they do not propagate to the next slide - it appears that the different OLE (?) views of the spreadsheet are not linked - that changes to one do not impact others.  Perhaps if I knew how to SAVE the changes ... using CNTL/S has no effect.
0
 
LVL 3

Accepted Solution

by:
saranyannarayanan earned 250 total points
ID: 35023636
In the paste special you can use the paste link option only for the display( cell which is used to display the changed value) it could help.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 3

Expert Comment

by:saranyannarayanan
ID: 35023676
Just check for the combination of when paste special with paste and paste special with Paste link work together , Paste should let you put values in and paste link should update the display with the changed value in the sheet based on the formula
0
 

Author Comment

by:IcelanderLight
ID: 35024132
Saranyannarayanan, let me try it tomorrow afternoon.  Thanks for the suggestions!  Will report tomorrow.  
0
 

Author Comment

by:IcelanderLight
ID: 35031201
Saranyannarayanan, I tried a variety of things.  None worked as I desired.  I did PasteSpecial (without link) and then PasteSpecial (with link) ... note the data source of these is the clipboard - changes to the PastSpecial (without link) do not propagate to the slide with PasteSpecial (with link) ...

I also tried OLE object ... I can get the the contents of the spreadsheet onto the slide and make alterations to it and see the formulas acting correctly ... but I cannot SAVE the Excel input from the PowerPoint slide back out to the Excel file.  Without that I cannot pull the new data in on a later slide.

I am coming to the conclusion that this is not possible - that I will have program it as a macro.

I appreciate your help and will award partial credit for the answers you sent.

0
 

Author Comment

by:IcelanderLight
ID: 35031476
I believe the only way I see to do this is to pull in the excelsheet with OLE to Slide A, make data entry, highlight the sheet in Slide A, go to EDIT/OBJECT/OPEN, save it with new name, and then in Slide B, use icon to pull in spreadsheet that was just saved in previous operation.  The saving of the spreadsheet could be handled with icon and macro on Slide A -  I would then see all the data I wanted in Slide B.

Calvin
0
 
LVL 3

Expert Comment

by:saranyannarayanan
ID: 35031506
If you use the same excel sheet , and do an update link using paste link it could work , I havent tried it yet . I will try and get back
0
 
LVL 24

Expert Comment

by:broomee9
ID: 35356991
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Setting the Scene Animations in PowerPoint are a great tool to convey messages when used carefuly with the content of your slides. There are plenty of animation effects and options, including a Repeat feature for individual animation effects. …
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question