We frequently use links from PowerPoint to Excel. I have recently
upgraded to Office 2007 and have encountered the following problem.

When linking from PowerPoint to a range of cells in Excel which
contains a chart (e.g.-the link is to Sheet1!$A$1:$L$50, there is some
data and the chart "covers the area from $C$4:$J$40), the PowerPoint
slide will not readily show the chart (as it would in earlier versions
of PowerPoint.) If I right click and chose update links, still no
chart. If I double-click and go to Excel, then right-click and update
link the chart will appear. Since our reports may contain dozens of
such links this is not a practical way to view the report. Updating
all links upon opening, or while in the document does not show the
charts. In earlier versions, charts always appeared.

Some investigation seems to indicate that the links to whichever sheet
in Excel may be active (whether the Excel file is open or not) will
update. Also, if the link is to the chart and not a range of cells
which contain a chart, then the link seems to update. Linking to the
chart itself creates other issues for us and is not always practical.
Links to ranges of cells with no charts operate as before.

I have tried saving files in various versions of both PowerPoint and
Excel and nothing seems to help. I have also looked through any
settings that I thought might be relevant but again no luck.

Is there any way to have to have PowerPoint 2007 display charts from
linked Excel worksheets?

Thanks.

Tony