Skip to main content

Remove the external links from an Excel File.

Sometimes its so happens that when you open an Excel file, it asks if the External Data needs to be updated or not. But you may not have intentionally given any external links. It’s an irritation then. But How to get rid of it?

Most likely it could be because of a Formula or a Named Ranges, although there are other possibilities as well.

1. How to identify the problematic Formula.

Goto the menu "Edit > Find" ( or press ) and enter as below and click "Find All".

2. How to identify the problematic Named Range.
Look for a Named Range that is linked to an external Workbook.

I do it this way.

go to an empty portion of the worksheet.
go to the Menu "Insert >> Name >> Paste" and click "Paste List".
Now you can manually search or use the method 1 to identify.

For the full info, click here.


-- said…
thanks.. it was useful..
Anonymous said…
You raise a lot of questions in my looks awesome too, thanks for the post.Hope to see more posts like these in future from you.
Toolbar Editor

Popular posts from this blog

TreeView Structure in Excel VBA

TreeView is extreamly useful in specific cases but it can be bit tricky sometimes to implement.  Last Few days I was working on a TreeView Structure and thought I will share the knowledge I gained...  This post takes you through the basic operations to create and operate a TreeView. It will be like the Folder tree window of the windows explorer.  Moreover, you can have it dynamically updated based on the data in excel.... Here we go..

Excel Function :TABLE

Its been a while since I have done some posting. This option in excel is something which I thought would be very useful for many. Its the TABLE Function in MS Excel. This is especially useful in the following scenarios.