Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

automatic links

  Asked By: Lourdes    Date: Sep 30    Category: MS Office    Views: 465
  

I had to copy my spreadsheet to another spreadsheet. Now, I have
automatic links to the original spreadsheet. Is there a way to list
and remove these links?

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Ricardo Smith     Answered On: Sep 30

I think it comes under Edit/Links.........

 
Answer #2    Answered By: Nora Martin     Answered On: Sep 30

Microsoft has a "Delete links  Wizard" Excel utility that will remedy the
problem for you.

http://support.microsoft.com/kb/q188449/

The Delete Links Wizard is an add-in file for Microsoft Excel that you can use
to delete links to external files in one or more workbooks. Currently, the only
way to perform this task is to manually delete the links or to use a Microsoft
Visual Basic for Applications macro to search, find, and delete the links. These
methods may require a significant amount of time if you want to remove  all the
links to external files. Using the Delete Links Wizard is more efficient than
manually deleting the links or running a macro because the wizard contains
options that make deleting multiple links easier. These options allow you to
easily delete any one of six kinds of links.

 
Answer #3    Answered By: Kenny Moore     Answered On: Sep 30

The wizard was great. Had one link.

 
Didn't find what you were looking for? Find more on automatic links Or get search suggestion and latest updates.




Tagged: