We are in the process of migrating from excel 2007 to excel 2013. Some of my users have workbooks that have accumulated a lot of excel names over the time and are no longer in use. Some of the names point to a URL that when opened in browser say, the certificate for this web site has expired.

Now when I open the workbook in excel 2007 it works the way it should work.

But when I open the same excel workbook in excel 2013, it tries to connect to the URL and gives me a message box that says the certificate has expired.

Why is this happening in excel 2013 but not in 2007?