PowerPoint 2007 - Automatically update links

[Jack21]

Hi, Can anyone help?

PowerPoint is used very heavily, in one particular department within my firm, to create reports. The reports tend to have a large number of excel charts included. The issue that has been raised with me is that when opening the PowerPoint report the excel chart links are updating automatically. I have noted in Excel that there is an option checked "update links to other documents" and was wondering if this was impacting the links being updated in PowerPoint?

Thanks
Jack

[HansV]

I don't think the Excel setting affects PowerPoint. If you don't want the charts to be updated, you should break the links.

[Jack21]

Apparently they still require the links but would like prefer the default to be to manually update. The automatically update links when a presentation is opened is causing frustrations when there are a large amount of charts. Is there a solution?

Thanks
Jack

[HansV]

Click the Office button.
Click Prepare.
Scroll down the list that appears.
Click 'Edit links to files'.
Select the chart links (use Ctrl+click if you want to select individual links).
Set Update to Manual.
Click Close.

[Jack21]

Morning Hans

I do not appear to have that option under Prepare. I have Properties, Inspect Document, Encrypt Document, Restrict Permission, Add a Digital Signature, Mark as Final and Run Compatibility Checker. Am I doing something wrong?

Thanks
Jack

[HansV]

It's a bit deceptive. When you click Prepare, you don't see the 'Edit links to files' option:

x479.png

Hover the mouse over the downward arrow to scroll the list. The option will scroll into view:

x480.png

[Jack21]

Thank you Hans. One more question, if you can help. Do you know if I can set this via the registry or a GPO setting?

Regards
Jack

[HansV]

The setting is stored in the presentation, it's not an application-wide setting...

[Jack21]

Thanks as always Hans.