<div>
I don't use Access but maybe this would work in PPT<br />
<br />

<pre><code id="code-20-38380426-1">Sub updater()
Dim osld As Slide
Dim oshp As Shape
For Each osld In ActivePresentation.Slides
For Each oshp In osld.Shapes
If oshp.Type = msoLinkedOLEObject Then
oshp.LinkFormat.Update
End If
Next
Next
End Sub</code></pre>
</div>


I don't use Access but maybe this would work in PPT



Sub updater()
Dim osld As Slide
Dim oshp As Shape
For Each osld In ActivePresentation.Slides
For Each oshp In osld.Shapes
If oshp.Type = msoLinkedOLEObject Then
oshp.LinkFormat.Update
End If
Next
Next
End Sub

<div>
Stepping through the code, the line<br />
If oshp.Type = msoLinkedOLEObject Then<br />
<br />
fails and goes to the next slide. &nbsp;No update
</div>


Stepping through the code, the line
If oshp.Type = msoLinkedOLEObject Then

fails and goes to the next slide.  No update

<div>
<div class="content wysiwyg-content">
I have a number of PowerPoint 2010 slides that have charts based on Access 2010 tables or queries.<br />
<br />
The base data changes daily. &nbsp;However, when I close and reopen the PowerPoint presentation/slideshow, the data is not refreshed.<br />
<br />
Is there a way (with code?) to force all of the slides to refresh without a warning box popping up?<br />
<br />
Thank you in advance.
</div>
</div>


I have a number of PowerPoint 2010 slides that have charts based on Access 2010 tables or queries.

The base data changes daily.  However, when I close and reopen the PowerPoint presentation/slideshow, the data is not refreshed.

Is there a way (with code?) to force all of the slides to refresh without a warning box popping up?

Thank you in advance.

Update PowerPoint 2010 chart based on Access 2010 table or query

PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint presentations consist of a number of individual pages or "slides" that may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. Slides can also form the basis of webcasts.

Microsoft PowerPoint

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.