Forum Discussion
LaurenceLau
Aug 21, 2019Copper Contributor
Workbook Keeps Asking to Update Links - Workbook Contains No External Links
Hello, I have stripped a very large workbook and have attached the sanitized data. There is one resulting cell (A1), which is shaded with no data. The data validation is set to allow any value. ...
LaurenceLau
Aug 21, 2019Copper Contributor
SergeiBaklan I have removed the macro, saved the file as .xlsx (see attached), but it is still asking for external credentials. Can you assist me as to why this is happening?
Subodh_Tiwari_sktneer
Aug 22, 2019Silver Contributor
Once the window, which asks for the credentials, is loaded, close it and do it for 3 times and your workbook will be opened normally.
The next step is, you will need to break all the existing links and to do that run the following macro when the problematic workbook is the ActiveWorkbook.
Sub RemoveExternalLinks()
Dim wb As Workbook
Dim exLinks As Variant
Dim i As Long
Set wb = ActiveWorkbook
exLinks = wb.LinkSources(Type:=xlLinkTypeExcelLinks)
For i = 1 To UBound(exLinks)
wb.BreakLink Name:=exLinks(i), Type:=xlLinkTypeExcelLinks
Next i
End Sub
And then change the Startup Prompt settings for the external links as shown in the image below.
Follow the steps exactly shown in the image.