Creating a powerpoint presentation from MS-Excel
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
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
.
|