Says it can't find links, but it can

SandsB

Well-known Member
Joined
Feb 13, 2007
Messages
617
When I open my file in Excel 2007, I get a pop-up that says:
This workbook contains one or more links that cannot be updated. To change the source of links, or attempt to update values again, click Edit Links. To leave the links as is, click Continue.

If I click continue, I see a list of several sources but no errors. I had an error the first time I opened this file today because I had renamed a source file. I pointed to the renamed file and problem solved. But this message keeps popping up every time I open the file. What gives?
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
some of the links can be quite hidden, like in graphs, or even in the macro's to be run (say a macro attached to a button)

Try editing the links and pointing the file to itself. That often cures it.

Save the file under a new name to test and see if all is well.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,361
Messages
5,635,808
Members
416,884
Latest member
leeshjay

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