Forum

Notifications
Clear all

Links in a File: cannot find the problem

7 Posts
3 Users
0 Reactions
98 Views
(@Anonymous)
Posts: 0
New Member Guest
 

Hi,

I have a document that had many refrences to other Excel files.

I recently changed it via Power Query so currently there is no connection to external file in any formula.

However I still get this message:

Edit-Links.jpg

I did "Show Formula" in all sheets, and checked for the file in the "Edit Links" dialog box, and found nothing.

How can I find the cells that look for these external files?

 

Regards,

Ayal Telem.

 
Posted : 13/10/2023 5:03 am
(@debaser)
Posts: 837
Member Moderator
 

Can you show us the Edit links dialog?

 
Posted : 13/10/2023 7:20 am
(@j8150outlook-com)
Posts: 51
Trusted Member
 

For you? Anything : )

Edit-Links-2.jpg

The first link is looking for a file that is the copy of the file I'm opening, a copy I created at one point, but never refrenced it in the original (even I wouldn't make such an idiotic refrencing).

The 2nd link is to a file that was once referenced to, but was then replaced by a PQ, and is now a sheet on the file I'm opening.

 

Regards,

Ayal Telem.

 
Posted : 14/10/2023 12:33 am
(@debaser)
Posts: 837
Member Moderator
 

Have you checked any conditional formatting formulas, data validation, charts, table formulas etc? Bill Manville’s FindLink add-in is very useful for things like this.

 
Posted : 15/10/2023 5:15 am
(@j8150outlook-com)
Posts: 51
Trusted Member
 

Hi Velouria,

Thanks for replying.

  1. Couldn't find the add-in you suggested. Searched for "FindLink", "Find Link" and "Manville".
  2. I thought that MS have a way to see the cells which have the problems, which, as far as I understand, they don't, which kinda puzzles me.
  3. For what ever reason, the Edit Links warning have stopped appearing. Probably something I did fixed it, but Excel was not aware of it...

Regads,

Ayal Telem. 

 
Posted : 16/10/2023 3:40 am
(@debaser)
Posts: 837
Member Moderator
 

Really? It was the first hit for me using those search terms: https://www.manville.org.uk/software/findlink.htm

 
Posted : 16/10/2023 7:38 am
(@j8150outlook-com)
Posts: 51
Trusted Member
 

Like I said the problem for this file was solved somehow, but I will donwnload for next time.

 

Thanks a million.

Ayal Telem.

 
Posted : 17/10/2023 7:48 am
Share: