I've created a new workbook and my cells have URLs in them. every time I open this workbook I get the following message box:

"this workbook contains links to one or more external sources that could be unsafe.

if you trust the links , update them to get the latest data. Otherwise, you can keep working with the data you have."

With the above message I have 3 buttons that give me the option to:

Update

Don't Update

Help

I have other workbooks that have URLs in the cells and I don't receive this error in them.

So my question is why am I getting this error only in one of my workbooks but not the others that have the same info?

And how do I get rid of this message

I'm using Excel 2013

Thank You

Keith

Hi Keith Aul,

Thanks for posting in MSDN forum.

This forum is for developers discussing developing issue about Excel. Since the issue is more relative to end-user, I would like to move it to Excel IT pro forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Regards & Fei

Hi,

As far as I know, this message is a Security Warning that Automatic update of links has been disabled.

To suppress the message and to automatically update the links when you open a workbook, follow these steps:   

1. Click Microsoft Office File, and then click Options.
2. Click Advanced.
3. Under General, click to clear the Ask to update automatic links check box.

https://support.microsoft.com/en-us/kb/826921 (It also applies to Excel 2013)

Regards,

George Zhao
TechNet Community Support

Hi,

As far as I know, this message is a Security Warning that Automatic update of links has been disabled.

To suppress the message and to automatically update the links when you open a workbook, follow these steps:   

1. Click Microsoft Office File, and then click Options.
2. Click Advanced.
3. Under General, click to clear the Ask to update automatic links check box.

https://support.microsoft.com/en-us/kb/826921 (It also applies to Excel 2013)

Regards,

George Zhao
TechNet Community Support