I have a workbook that gives me the spiel about it having external links and asking if I want to update them. I in fact want them gone as they should only point to places within the workbook.
So, I searched for all occurrences of ".xl" in the formulas. I found some and fixed them up and now the search yields no new finds suggesting it is fixed. Yet I still get the message when I open the file. So I decided I would track it down by cornering it. I made a copy of the workbook. I deleted half of the pages, saved it and reopened it. This tells me the link(s) are in the pages I deleted. So I did that again, deleting the other half instead, saved it and reopened it and again no message. So the link is evidently in neither half of the pages and no ".xl" strings are found in my search, yet when I open the entire workbook it tells me there are links.
Is there something I'm missing?
So, I searched for all occurrences of ".xl" in the formulas. I found some and fixed them up and now the search yields no new finds suggesting it is fixed. Yet I still get the message when I open the file. So I decided I would track it down by cornering it. I made a copy of the workbook. I deleted half of the pages, saved it and reopened it. This tells me the link(s) are in the pages I deleted. So I did that again, deleting the other half instead, saved it and reopened it and again no message. So the link is evidently in neither half of the pages and no ".xl" strings are found in my search, yet when I open the entire workbook it tells me there are links.
Is there something I'm missing?