Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Excel OLE within PowerPoint

Posted on 2011-03-02
10
1,230 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

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.
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

856 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