+ 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 Expert xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    4,330

    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.
    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)

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