Thread: [Solved] Macro for Copying Charts to Powerpoint
View Single Post
 
Old 10-01-2013, 03:27 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi bremen22,

Have you tried copying & pasting the Excel charts into your presentation, using Powerpoint's Paste|Paste Special>Paste Link option? That way, you shouldn't need any code to keep it in synch with the Excel data. Indeed, if the Excel workbook is open at the same time as the Powerpoint presentation is open, there will be no appreciable delay between the data in Excel being updated and the updates appearing in the presentation.

If that isn't suitable, can you attach a document to a post with some representative data (delete anything sensitive) and the code you're using? You do this via the paperclip symbol on the 'Go Advanced' tab. That way, it should be possible to quickly diagnose the problem.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote