Updating linked Charts automatically in Powerpoint when open

KOLM#S

Board Regular
Joined
Jun 2, 2006
Messages
63
Hi
I'm using the VBA below to open a Powerpoint presentation from Excel. I have created several charts in the presentation that source thier data from areas in the excel document. These charts are linked but I can only get them to update if I double click on each chart to reveal the hidden powerpoint data sheet......

Application.ScreenUpdating = False
Dim PowerPointApp As Object
Set PowerPointApp = CreateObject("PowerPoint.Application")
PowerPointApp.Visible = True
PowerPointApp.presentations.Open ("V:\Intelligent Board\PowerPoint 2006-07\PowerPoint April.ppt")
Application.ScreenUpdating = True[/code]

Is thier anyway of making these charts update automatically upon opening??????

MANY THANKS
KOLM#s :confused:
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,983
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Try this:

Code:
PowerPointApp.presentations.Open "V:\Intelligent Board\PowerPoint 2006-07\PowerPoint April.ppt"
ActivePresentation.UpdateLinks
 

KOLM#S

Board Regular
Joined
Jun 2, 2006
Messages
63
Hi Jon

Many Thanks for your reply.... unfortuntely when i run the VB below it breaks down on the last line saying that I have not defined the variable.... I've had several attempts at definig a variable and failed miserablly!!!!! any chance you can advise??????


Dim PowerPointApp As Object
Set PowerPointApp = CreateObject("PowerPoint.Application")
PowerPointApp.Visible = True
PowerPointApp.presentations.Open "V:\Intelligent Board\PowerPoint 2006-07\PowerPoint April.ppt"
Activepresentations.UpdateLinks

Many Thanks
KOLM#s :oops:
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,983
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
1. ActivePresentation is singular
2. You need to reference it as PowerPointApp.ActivePresentation
 

KOLM#S

Board Regular
Joined
Jun 2, 2006
Messages
63
Hi Jon

Many thanks, that now runs without breaking down, however, I sill have to double-click on the chart in powerpoint to make it update?????

Any further suggestions on how to automate this?????

many thanks
KOLM#s
:confused:
 

Forum statistics

Threads
1,148,195
Messages
5,745,285
Members
423,942
Latest member
excelhelp1423

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top