Forum Discussion
Workbook Keeps Asking to Update Links - Workbook Contains No External Links
First, it asks external credentials
Second, external file
and some others.
All links are within your VBA code, in particular
...
Set fso = CreateObject("Scripting.FileSystemObject")
If fso.FolderExists("F:\SHAREBOX\SALES\Pricing Tool\Extracts\Mining\") Then
path = "F:\SHAREBOX\SALES\Pricing Tool\Extracts\Mining\"
Else 'for Houston PC's that link H instead of F for sharebox
If FileThere("H:\SHAREBOX\SALES\Pricing Tool\Extracts\Mining\") Then
path = "H:\SHAREBOX\SALES\Pricing Tool\Extracts\Mining\"
Else
'generic for people who don't have linked drive letters
path = "\\ZEUS\SYS\SHAREBOX\SALES\Pricing Tool\Extracts\Mining\"
End If
End If
...
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?
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 SubAnd then change the Startup Prompt settings for the external links as shown in the image below.
Follow the steps exactly shown in the image.
It looks like links are in cache for A1 data validation.
If copy/paste any empty cell to A1 links disappear.
When I click on Cell A1 --> Data Validation, the prompt informs me that cell A1 allows any value.
Also, I can enter the value "123" that you entered in your screenshot. You can still see the "Enable Content" prompt in my screenshot below.
Is there something wrong with my version of Excel? Thanks.
I checked on another PC - behavior is approximately as in your case. Nonetheless, if unzip your file and check xml inside - it has 4 external links and lot of related data, it looks like they are connected to data validation.
I can't say exactly why it's so. Practical step - if you clean cell A1 (replace it by any empty cell), external references disappear and file works without errors.
