External internet links in hanging file

screaming

New Member
Joined
Nov 17, 2017
Messages
8
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
 

Attachments

  • error message external links.PNG
    error message external links.PNG
    86 KB · Views: 16

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,790
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Is it only one file that has the problem?
 

screaming

New Member
Joined
Nov 17, 2017
Messages
8
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,790
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
See if you can locate Bill Manville's FindLink add-in, which is a good place to start.
 

JenniJames

New Member
Joined
Aug 24, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

New Member
Joined
Nov 17, 2017
Messages
8
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?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,134
Messages
5,835,601
Members
430,369
Latest member
pingel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top