I have a workbook that has 9 "Chart" sheets in it. These are Piviot charts for different things. The data that drives the pivot tables is pulled in by an automatic Oracle Query. I need a method to copy these charts and paste them into a Powerpoint presentation.

I have tried inserting an object from the spreadsheet, but when my spreadsheet refreshes (set on a timer) all 9 charts look the same.

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]