Excel 2016
Opening a workbook identifies a link to an earlier version of this workbook
Data->Links confirms this link to an earlier version of this workbook
THe workbook is not protexted. None of the sheets in teh workbook are protected.
I click change source, select the current version (actually the workbook that is open and in which I am trying to make this change)
click OK but the reference does not change
I have searched the workbook for this reference but it cant be found
I have searched the workbook for [ and it finds a number of references to the current workbook [they are in cell A1 on different sheets which contains the function Cell("filename"] but none to the earlier version identified by edit->link
I simply cant find the cell with the link
I search the text in my macros and vba code but cant find the reference there
So I go for 'Break Link'. Accept the warning
But data->edit link continues to report the same link
File save and Open
But data->edit link continues to report the same link
So please how can I find this link and make the problem go away?
TFAI
Bookmarks