+ Reply to Thread
Results 1 to 2 of 2

Formulas of an embedded excel in powerpoint don't work unless I double click them

  1. #1
    Registered User
    Join Date
    04-02-2017
    Location
    Kiel, Germany
    MS-Off Ver
    2010
    Posts
    6

    Formulas of an embedded excel in powerpoint don't work unless I double click them

    Hi guys,

    I found some similar threads on the internet, but they couldn't help a lot.

    I have an Excel Table embedded in PowerPoint. It has some formulas, which use the VLOOKUP function to show some values from another Excel file. The problem is that when the values in the original file are changed, the embedded table doesn't refresh (it shows the old values). When I double click the cells with the formulas they get refreshed. Is there some way to refresh the embedded table? The recalculation is set to automatic. But it seems that it doesn't get executed. When I go to "Data -> Edit Links -> Update Values" it updates them. But it doesn't do that automatically. With "Data -> Edit Links" I see the source file as a link. But when I go out of the excel table and I check in the PowerPoint it doesn't show to have some linked files.

    I coded a Macro that rewrites the formulas every time, so they get refreshed. There is a line for every cell simillar to this:

    ActivePresentation.Slides(2).Shapes(1).OLEFormat.Object.Sheets(1).Range("C4").Formula = "=VLOOKUP(L_BP_PROJEKTID,..........,COLUMN(........),FALSE)"

    The problem is that the structure of this table gets changed very often. And I have to change the Macro every time and add the new reference to the new cell.

    Is there a chance to write a Macro that will refresh the whole table? I think of something like either refreshing the whole excel sheet or writing a macro that goes through all the cells and activates every one of them. I tried with the command "activate" but it doesn't work.

    Many thanks for your help in advance!
    Last edited by Martin_Ko; 10-02-2017 at 08:02 AM.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Formulas of an embedded excel in powerpoint don't work unless I double click them

    Hi,

    I have not had a chance to test but perhaps
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Formulas of embedded excel table don't update, unless I double click them
    By Martin_Ko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2017, 06:32 AM
  2. Using VBA to refresh Excel Links embedded in PowerPoint
    By NotYoda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2017, 09:02 AM
  3. [SOLVED] Referring to an embedded excel worksheet in powerpoint
    By Martin_Ko in forum PowerPoint Programing
    Replies: 2
    Last Post: 04-10-2017, 02:27 PM
  4. Excel 2010 Double click not work ? since replace PC .
    By ks1102 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2016, 03:29 AM
  5. Changing cell properties with double click, then revert with another double click
    By mweber2525 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-01-2014, 01:40 PM
  6. Update embedded excel containing sql in powerpoint
    By DeNam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2013, 08:23 AM
  7. Embedded chart in Powerpoint to Excel
    By JWoodrell in forum Excel General
    Replies: 0
    Last Post: 01-20-2012, 02:43 PM

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