asked on

Find out the links

Hi,
Where to find out which links inside Excel 2003 Workbook, are pointing to any other Excel files (or retrieving any details from other Workbook), which is causing the attached message coming out?
tt309.jpg

Rgonzo1971

Hi,

pls try

Data / Connections /Edit Links

Regards

Kanti Prasad

Hi

In the below link follow the method 2. When you highlight any cell you will know if there is a formula and if that is being linked to another xls or source.

http://www.keynotesupport.com/excel-basics/excel-linking-worksheets.shtml

ASKER CERTIFIED SOLUTION

Saurabh Singh Teotia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

[ fanpages ]

All of the off-site links aside, Dave Brett wrote an article at Experts-Exchange in 2011 on this very subject:

"Excel code to find and report on links in the selected ActiveWorkbook (formulas, range names, pivotTables & charts)"

[ https://www.experts-exchange.com/articles/972/Excel-code-to-find-and-report-on-links-in-the-selected-ActiveWorkbook-formulas-range-names-pivotTables-charts.html ]

Peter Chan

ASKER

Thanks. I can not find out

Menu > Data > Connection

within Excel 2003.

And within VBE, I also do not see where

Insert-Module

is.

Martin Liss

I've requested that this question be deleted for the following reason:

The question has either no comments or not enough useful information to be called an "answer".

Saurabh Singh Teotia

Did you try the add-in which i said..?? If you run that add-in it automatically list the links of your workbook and you can take any operation on it whatever you want to do..

Saurabh...