EXCEL: detect automatic links 2

[firegambler]

Hi,

I have this excel file that opens a dialogue box when ever the file is opened. It says that there were automatic links to information in other files and whether I would like to update this information or not.
Unfortunately I cannot find those links to the other files.
I'd like to remove them.

Is there any way to detect those links?

Thanks in advance

regards

 

[gizmo1973]

In Excel 2000, you can go Edit, Links.
This will then show active links to the data source and the source file.

Regards, Phil.

M.U.F.C. Show your true support here, it's still not too late:

http://shareholdersunited.org/join.php?ref=125059000

"Where there's blame there's DPlank"

 

[GlennUK]

If your version of Excel is prior to 2000, then download Bill Manville's FindLink add-in. You can find it here:

http://www.bmsltd.ie/MVP/

Unzip it, do menu command Tools/Add-Ins to add it in, and look under Tools to use the new command to find the links.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[firegambler]

Great Guys! Thanks!!

regards