+ Reply to Thread
Results 1 to 3 of 3

Reference Excel cells on different slides in Powerpoint

  1. #1
    Registered User
    Join Date
    01-05-2011
    Location
    LA, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Reference Excel cells on different slides in Powerpoint

    Hi all,

    I ultimately want to have one worksheet embedded in slide 1 of a powerpoint and another worksheet embedded in slide 2. Problem is that I want to do something like A1 of worksheet1 = A2 + B5 of worksheet 2.

    The way I have it set up right now is that there's one workbook in slide 1 and one workbook in slide 2. I double click on the workbook in slide 1 and start to put in the equation, but once I try to select the workbook on slide 2, it jumps out and never finishes.

    I was wondering if there's an easy way to "link" cells between workbooks in excel. I'm not sure if that's possible or not. A solution that may work is if I can create one workbook, but somehow have it show up on both slides...that way I can reference within the workbook. I also want the values to change as I enter information, because I have to update the worksheets all the time. Linking to an .xls is not an option, because I want a standalone .ppt with all the information I need.

    Is it possible to do this using VB scripts? I'm not familiar with any of that, so if anyone can step me through, I would greatly appreciate it.

  2. #2
    Valued Forum Contributor
    Join Date
    10-17-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013, 2016, 2019, 365
    Posts
    286

    Re: Reference Excel cells on different slides in Powerpoint

    I think you do need to link to a separate workbook (happy to be proved wrong!). This isn't a problem for the master copy of your presentation, as it'll be in the right place and always able to find the latest data.

    Afterwards, if you want to use a standalone copy of the presentation, just select 'cancel' when it asks if you want to update the external links, then it'll use the latest data it had.

    You now have a master which can be updated from the spreadsheet as required, and standalone copies which use the data as it was when the standalone was created.

    I think that's probably the best you can do.

  3. #3
    Registered User
    Join Date
    01-05-2011
    Location
    LA, CA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile Re: Reference Excel cells on different slides in Powerpoint

    Quote Originally Posted by outofthehat View Post
    I think you do need to link to a separate workbook (happy to be proved wrong!). This isn't a problem for the master copy of your presentation, as it'll be in the right place and always able to find the latest data.

    Afterwards, if you want to use a standalone copy of the presentation, just select 'cancel' when it asks if you want to update the external links, then it'll use the latest data it had.

    You now have a master which can be updated from the spreadsheet as required, and standalone copies which use the data as it was when the standalone was created.

    I think that's probably the best you can do.
    Thanks for the response. The problem is that I don't want to link to a separate workbook. By linking, I would need both a ppt and an xls for the most up to date data. I am planning to send this stuff to 100+ people who will each make their own changes and would be sending it back and forth between people. I don't want the data to get lost by the many different copies and versions of ppt and xls. That's why I want to embed the excel sheets inside the powerpoint, that way I only have one ppt to worry about and that file will always have the most up to date data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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