Creating a powerpoint presentation from MS-Excel

S

Shilps

Hi,
I have an excel sheet which keeps getting updated every month. I need to create a powerpoint presentation based on the data captured in this sheet. Is there any method of doing it?
TIA
Shilps
 
K

K Dales

If you just want a copy of the worksheet to be in the
presentation (and to automatically update so any changes
in the Excel file show in the presentation file) use (from
Powerpoint) Insert... Object... Microsoft Excel
Worksheet. Choose "Create from file" and specify the
Excel file and make sure the box marked "Link" is
checked. The link ensures that the latest copy of the
file is loaded whenever the presentation loads.

However, if you need to use individual cell values and
insert them somewhere into the text of the presentation
(e.g. "Our margin in April was $200,000...") this would be
trickier and would require some pretty advanced VBA coding.
-----Original Message-----
Hi,
I have an excel sheet which keeps getting updated every
Click to expand...
month. I need to create a powerpoint presentation based on
the data captured in this sheet. Is there any method of
doing it?
 
S

Shilps

Actually, I want to create a powerpoint presenation, with all the formatting on the basis of data in Excel. I do not want to embed Excel sheet in Powerpoint. I know it has to be done through VBA but I am stuck where to start, how to do it. Could find nething in VB help also
 
Top