+ Reply to Thread
Results 1 to 1 of 1

Automate Excel Data to PowerPoint

  1. #1
    Registered User
    Join Date
    07-07-2019
    Location
    Pennsylvania
    MS-Off Ver
    365
    Posts
    25

    Automate Excel Data to PowerPoint

    1) I just subscribed to Commercial Service so that I can try to get help on the below. Anyone know how that works or where I am supposed to post it?


    2) -Screenshots with explanations of below - ATTACHED

    -DYNAMIC LINK Between Excel Template and PowerPoint Template

    WHAT I HAVE:
    -Have a custom made Excel Template (Fillable) that requires the user to input data into certain fields. Once these fields are filled, the other sheets are updated with that data in a "rough" report. These other sheets/reports and their data (updated multiple times daily for different clients) - are to then be SENT to PPT.
    -Also have a custom PowerPoint Template (Linked to that Excel Template) which is supposed to auto-update from the above Excel template.

    -Both open "fresh" every time they are needed.
    -User will open both, they will fill in the required fields within the Excel template, the PowerPoint Template will update, and then the user will either send the PP Presentation for use, or print the PowerPoint Presentation for use.

    *I have created a very large, multi-sheet Excel Template that is designed to have a User open the template, complete the required fields based on the specific client, and then be able to generate reports. Initially I had handmade the reports in Excel and they work fine, but for the sake of it, visually not being the most attractive thing in the world, I've now created a PowerPoint Template which has taken the visuals full circle, however I am having an issue with the linking.

    ISSUE:
    Data from Excel updates like it should (tested) initially. After pasting/linking a few more fields, the first and subsequent fields stop updating when data is changed within the Excel file.

    ***When I paste special/paste link into PPT, it works fine after testing ( updating the data in Excel and seeing the update in PPT) but then after pasting 3-4 more of these linked cell ranges into the PPT - The link from the first/second/so on BREAKS and it no longer updates. If I save the PPT and close it, when re-opened, none of the links are found and none function.
    **Here is the process I have been using, which is not working: Copy a range of cells within the Excel template < Open the PowerPoint < "Paste Special" < Paste Link < Select Excel

    ***When I paste special/paste link into PPT, it works fine after testing ( updating the data in Excel and seeing the update in PPT) but then after pasting 3-4 more of these linked cell ranges into the PPT - The link from the first/second/so on BREAKS and it no longer updates. If I save the PPT and close it, when re-opened, none of the links are found and none function.

    I have tried saving them to saving them to one drive/auto save. I have also tried just saving them on the desktop as well. Not sure if that has an impact?

    PLEASE let me know if (1) there is something I am simply doing wrong? OR if there are any available Apps (Paid or Free) within the Microsoft App store that can accomplish this task/issue for me.

    Any assistance on this will be greatly appreciated. Thank you.

    - - -
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 01-06-2017, 07:08 AM
  2. Replies: 0
    Last Post: 08-23-2016, 09:43 AM
  3. Excel/PowerPoint VBA teaser: How to change data labels in PowerPoint chart by VBA?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 11:47 AM
  4. Replies: 0
    Last Post: 07-05-2012, 03:44 PM
  5. Data input in powerpoint to select data in excel and report back to powerpoint
    By daveybright in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2009, 09:54 PM
  6. [SOLVED] How to automate "Excel data .. pasting to... powerpoint"
    By dstdst123@excite.com in forum Excel General
    Replies: 2
    Last Post: 02-23-2006, 11:55 AM
  7. [SOLVED] Automate Excel to powerpoint - Graphs along with Datasheet (not workbook)
    By Hari Prasadh in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-18-2005, 10:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1