Excel error - "We can't connect to 'https://sharepoint...."

First error

Clicked "ok" - second error

The worksheet is not on Sharepoint, and there are no links or connections attached to the spreadsheet. All data required for the file is contained on the worksheet. None of the formulas on the page are indexed to anything not on this worksheet.

Answer
Answer

After working with the user we discovered that there was a "Defined Name" for this link under the "Name Manager" on the "Formulas" tab of Excel 2016.

When these "Defined Names" are removed the error goes away. If you are having this issue please reference the below support article:

https://support.office.com/en-ie/article/find-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1

Make sure that you complete the 4 steps at the bottom as well, as this is where out problem was:

32 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated August 12, 2020 Views 20,296 Applies to: