Dear,
Concern: Excel 365 with an yearly abonnement to Microsoft
I fighting since a few years in order to find a ghost link (appearing in the menu of data EDIT LINK). This ghost link refer to a sheet in an 4 years old workbook.
My workbook has several (21) sheets.
After having try all possible solution, I made a copy of my workbook and put is in another directory and I verified that the ghost link was copy with the workbook.
Then I cancel, sheet after sheet till the ghost link disappear. In this way I identified which sheet was containing the link.
Once I had identified the sheet in my copied workbook, I canceled row per row and also the conditional formatting and the validation data in it, till I stood with a blank sheet and still the ghost link was there. But when I cancel this blanked sheet and take it out of my workbook the ghost link disappear
What should I do to kill this stupid link?? I have try every possible trick and also all the possibilities of the data EDIT LINK, I killed all conditional formatting and also all data validation conditions.
Now it is possible that the sheet was generated by means of an old one in a previous workbook to which the ghost link is referred, but all data, formula’s, conditional formatting and data validation was changed in the years
Best regards
C. Peten
Concern: Excel 365 with an yearly abonnement to Microsoft
I fighting since a few years in order to find a ghost link (appearing in the menu of data EDIT LINK). This ghost link refer to a sheet in an 4 years old workbook.
My workbook has several (21) sheets.
After having try all possible solution, I made a copy of my workbook and put is in another directory and I verified that the ghost link was copy with the workbook.
Then I cancel, sheet after sheet till the ghost link disappear. In this way I identified which sheet was containing the link.
Once I had identified the sheet in my copied workbook, I canceled row per row and also the conditional formatting and the validation data in it, till I stood with a blank sheet and still the ghost link was there. But when I cancel this blanked sheet and take it out of my workbook the ghost link disappear
What should I do to kill this stupid link?? I have try every possible trick and also all the possibilities of the data EDIT LINK, I killed all conditional formatting and also all data validation conditions.
Now it is possible that the sheet was generated by means of an old one in a previous workbook to which the ghost link is referred, but all data, formula’s, conditional formatting and data validation was changed in the years
Best regards
C. Peten