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!!!!!!
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!!!!!!
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.
thanks bro!!!!
Is there a way of doin it through vb codes/macros????
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
Versions
Mac OS X 'Leopard'
Mac MS Office Excel 2004
Windows XP
MS Excel 2002
MS Excel 2003
Going to need some serious editing as well!
But at least it will give you an idea of what to do.
thanks a ton mate!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks