Automatically retrieve data from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Client has requested that all tables and graphs be created in PowerPoint for
their final report. Our challenge, for efficiency is to pull data from an
Excel file to populate this report automatically. These reports are done on
a monthly basis so we don't want to cut and paste the data in the PP
datasheets.
 
Client has requested that all tables and graphs be created in PowerPoint for
their final report. Our challenge, for efficiency is to pull data from an
Excel file to populate this report automatically. These reports are done on
a monthly basis so we don't want to cut and paste the data in the PP
datasheets.
Click to expand...

One approach:

When creating a chart in MSGraph (ie, the program that PowerPoint invokes when
you insert a graph) you can link to data in an Excel sheet.

If you do that, the graph will update from the Excel data whenever the graph is
activated. That would require that

- a user doubleclicks each graph or
- you supply a code solution that'd activate and close each graph automatically
 
Back
Top