External internet links in hanging file

[screaming]

Hi all

When I open a file I am getting various error messages saying " downloading, opening:https://mydanaher.com/documents and settings/MikeG/Local Settings/Temporaty Internet Files/OLK19/TEMP/2000PD-White-Nove00.xls and various other links.

Message then says it can't access file, then another messages says "cannot locate the internet server or proxy server", it then hangs.

I have no idea where these links come from. They don't appear in the data, edit links box. I can't see any formulas link to them either.

How do I get rid of them? I'm panicking as templates are due out today and this was what was picked up in the testing stage.

Also is there a macro or solution which lists all the formula cell addresses in my file with external links.

Thank you for any suggestions.

Screaming Orchid

 

[RoryA]

Is it only one file that has the problem?

 

[screaming]

Is it only one file that has the problem?

It is more than one file, different versions of the same file. I've had it before when I receive excel files from external accounts- full of external internet links. not sure how to get rid of them.

 

[RoryA]

See if you can locate Bill Manville's FindLink add-in, which is a good place to start.

 

[JenniJames]

Hello,

I have the same problem... Getting a message about MikeG local settings but there's no one in my company with that username. I was able to find and remove the bad links, but it's alarming to see a link to an unfamiliar url.

Jenni

 

[screaming]

Hello,

I have the same problem... Getting a message about MikeG local settings but there's no one in my company with that username. I was able to find and remove the bad links, but it's alarming to see a link to an unfamiliar url.

Jenni

Yes I think I've also got MikeG local settings. It is alarming, I'm going to inform our IT department. It's I have about 20 of these and it's grinding my model to a halt. Did you have macros in your file?

 

[JenniJames]

Hi, Yes the files have macros in them.