Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > PowerPoint

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-05-2017, 05:57 AM
Martin_Ko Martin_Ko is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2017
Posts: 1
Martin_Ko is on a distinguished road
Default 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.O bject.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!
Reply With Quote
Reply

Tags
excel 2010, powerpoint 2010, vba
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Single embedded excel sheet for multiple graphs in PowerPoint GOCPT PowerPoint 1 07-26-2017 04:20 AM
Double Click to show white space James__S Word 3 09-15-2016 07:57 AM
Create Several PowerPoint Charts From One Embedded Excel worksheet Galapagos15 PowerPoint 0 10-30-2015 06:19 AM
Excel Files Won't Open With Double Click ykhalil Office 1 11-10-2014 05:00 AM
Play Shockwave on a double click dedine PowerPoint 4 06-03-2013 08:26 AM


All times are GMT -7. The time now is 02:34 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft