I have researched until I am researched out. I get this annoying message every time I open my Workbook telling me I have links that will not update. When I click on edit links it brings up the list of links that are all years old versions of this workbook and long since been deleted. I have tried selecting all and breaking the link, but nothing happens. I have changed the startup prompt to 'Don't display the alert and update links' , but that doesn't seem to work either. I have done the whole Ctrl-f and the [ thing. There is none in my entire workbook. I have deleted all data validations. I have done the Check for Issues and deleted all hidden content. Yet still NOTHING IS WORKING!!! Someone please help me get rid of these links!! Thank you in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Links will not break!
- Thread starter Sarche
- Start date
63falcondude
Well-known Member
- Joined
- Jan 15, 2016
- Messages
- 3,572
I just solved a similar issue for a co-worker. A lot of things to check.
Do you have Conditional Formatting?
Note that once you find and break the link, you will have to save, close, and reopen your file for the link to go away.
Do you have Conditional Formatting?
Note that once you find and break the link, you will have to save, close, and reopen your file for the link to go away.
Last edited:
Upvote
0
No, I do not have any Conditional Formatting in my Workbook. I have even tried save, close, reboot computer, and reopen file and it is still not working.
Upvote
0
63falcondude
Well-known Member
- Joined
- Jan 15, 2016
- Messages
- 3,572
Take a look though File, Check for Issues, Check Compatibility to try to find any references to other workbooks. Another thing to try is changing the source of the link to itself. If these don't work, can you upload the file to a file sharing website such as drop box so that we can take a deeper look?
Upvote
0
Dr. Demento
Well-known Member
- Joined
- Nov 2, 2010
- Messages
- 618
- Office Version
- 2019
- 2016
- Platform
- Windows
The only success for those "Klingons" that I have found is to create a new workbook, pasting the data as values into the new workbook. However, that may not be a viable option depending on your particular situation.
That being said, have you tried this potential solution by Chris Newman?
That being said, have you tried this potential solution by Chris Newman?
Last edited:
Upvote
0
Similar threads
- Question
- Question
