Copying Data From Excel to a Powerpoint Presentation

[Vishal Dsouza]

Hi All,

Can anybody help me out by telling me hw can i transfer data from a range in an excel sheet to a powerpoint presentation??????

Thanks to all in advance!!!!!!

[scanavan]

I've recently discovered this so you will need to test it.

Create a graph in your excel file.

Cut the graph and paste it into the powerpoint presentation.

At this stage you can now delete the graph but the excel tabs in the background will remain active and allow formulas that can reference to your excel file.

I have experienced two difficulties with this:

- Its best to write your cell references in excel before doing cut / paste as its difficult to write them in powerpoint
- If you ever change the data in excel, you need to open the presentation and refresh the excel extract manually by double clicking on it.

[Vishal Dsouza]

thanks bro!!!!

Is there a way of doin it through vb codes/macros????

[JR@SGC]

Heres some sample vba code if your feeling brave!
Not my code no idea were it came from (been years since ive used)

Please Login or Register  to view this content.

[JR@SGC]

Going to need some serious editing as well!
But at least it will give you an idea of what to do.

[Vishal Dsouza]

thanks a ton mate!!!!!