Embedded Excel links in Powerpoint

Question

Hello,

We are having issues with PowerPoint presentations which has embedded excel links. On opening the presentation, it prompts to update the links. On clicking on Update links, it gets stuck and does nothing.

Workaround that works is if we hit cancel and then update the links in File-> Info-> Edit links. However, we would like to get it fix when initial prompt shows up.

Thank you for the help in advance.

Answer 1

Hi Bhavpreet,

To help protect your security and privacy, the Microsoft Office system is configured by default to block external content such as images, linked media, hyperlinks, and data connections in workbooks and presentations. Blocking external content helps to prevent Web beacons and other intrusive methods that hackers use to invade your privacy and lure you into running malicious code without your knowledge or consent. Let us change some settings for workbook links and check if this will help resolve the issue. Please follow the steps below:

1. In Excel, click the Microsoft Office Button , and then Excel Options.
2. Click Trust Center, click Trust Center Settings, and then click External Content.
3. Click the option that you want under Security settings for Workbook Links:

           a. Enable automatic update for all Workbook Links

• Click this option if you want links to data in another workbook to be updated automatically in the current workbook without receiving a security warning. Automatically updating links to data in workbooks that you are not familiar with can be harmful. Use this option only when you trust the workbooks that the data is linked to. You may want to select this option temporarily, and then return to the default setting when you no longer need it.

           b. Prompt user on automatic update for Workbook Links - This is the default option. Click this option if you want to receive a security warning whenever you run automatic updates in the current workbook for links to data in another workbook.

           c. Disable automatic update of Workbook Links - Click this option if you don't want links in the current workbook to data in another workbook to be updated automatically.

Let us know if this will help resolve your issue.

Thank you.

Answer 2

Hello Anna,

Thank you for responding back.

I understand that Microsoft has blocked the external content for security reasons. However, the steps that you have specified are for excel and the issue is with PowerPoint. 

Can you please let me know what all the steps needs to be done to fix it for PowerPoint?

Thank you.

Answer 3

When this happens, how are you opening the PowerPoint file?

That is, do you:

• Doubleclick the file's icon to start PowerPoint and open the file, or ...
• Start with PowerPoint open, then use File | Open to open the file, or ...
• Open the file from the recent files list in PowerPoint?

If the third option is what you're using, try either of the other two and see if that makes any difference.

Answer 4

Hello Steve,

The PowerPoint is opened by double clicking on the file.

Thank you.

Answer 5

Hi Bhavpreet,

To help protect your security and privacy, the Microsoft Office system is configured by default to block external content such as images, linked media, hyperlinks, and data connections in workbooks and presentations. Blocking external content helps to prevent Web beacons and other intrusive methods that hackers use to invade your privacy and lure you into running malicious code without your knowledge or consent. Let us change some settings for workbook links and check if this will help resolve the issue. Please follow the steps below:

1. In Excel, click the Microsoft Office Button , and then Excel Options.
2. Click Trust Center, click Trust Center Settings, and then click External Content.
3. Click the option that you want under Security settings for Workbook Links:

           a. Enable automatic update for all Workbook Links

• Click this option if you want links to data in another workbook to be updated automatically in the current workbook without receiving a security warning. Automatically updating links to data in workbooks that you are not familiar with can be harmful. Use this option only when you trust the workbooks that the data is linked to. You may want to select this option temporarily, and then return to the default setting when you no longer need it.

           b. Prompt user on automatic update for Workbook Links - This is the default option. Click this option if you want to receive a security warning whenever you run automatic updates in the current workbook for links to data in another workbook.

           c. Disable automatic update of Workbook Links - Click this option if you don't want links in the current workbook to data in another workbook to be updated automatically.

Let us know if this will help resolve your issue.

Thank you.

According to you screen shot you using Windows version The Mac version don't use Trust Center to my knowledge. 

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.