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.
Labels:

Comments

-- said…
thanks.. it was useful..
Friday, March 26, 2010 3:50:00 am
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
Wednesday, February 29, 2012 1:25:00 pm
Post a Comment

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..
7 comments
[ Read more » ]

Controlling LED through Octolapse for 3D print timelapse

Today's post is about one of the 3D Printing adaptation that I learned. This is specifically about how to control an LED light automatically through OctoLapse so that it is switched on only when the timelapse photo is taken. Just as a background, I have been learning to use 3D printer and its customizations options for a few months now and was a lot of learning since then. The best thing was OctoPi, a platform for controlling the 3D printer and the many plugin options that are developed by the community.  Most of them are like open source. Today we will discuss specifically about an adaptation to one such plugin, OctoLapse. OctoLapse is the plugin for taking timelapse photos, with many options for further customisations. One of the best timelapse method is taking photo after each layer is complete, by moving the head out of the way. You can use standard Pi Camera or a DSLR, which is great to get good resolution videos. One small flash back before we dive into the topic.  I keep the
Post a Comment
[ Read more » ]

PTC Creo | my Mapkeys for free

I have created a list of frequently used mapkey shortcuts for the PTC Pro Engineer Creo. This is the macro equivalent in creo.  I am copying them below.If you need them, copy paste the content to the "config.pro" file in your startup folder. My favourites are highlited and greatly improves the workflow.. For ex, to reach MEASURE. need to go to another menu and click.  Instead, maypkey from any selected menu on the ribbon will work.. Thats wonderful to me... Also, Edit Sketch (ES) is overloaded and will work for Extrusion, Revelution, Sweep etc.. So is aa, pp, zz..  really helps me a lot.. Hope you will start using them as well and get benefited! Let me know in comments, your feedback and issues.... Sketch View           > sv Show and Erase        > se Working Directory     > wd Hiddel Line View      > hi Close (quit) Window   > qw Measure               > mm Erase Session         > ee Insert Mode @ Sel     > is Cancel Insert Mode    > ic edit Sketch
Post a Comment
[ Read more » ]