False links. How to get rid of them?
Posted by Lieuwer on June 23, 2001 11:32 PM
My Excel application wants to update links that are not there. These links apeared after a faulty macro exported or copied a sheet out of the workbook.
Thanks to ALADIN who suggested to clean up the names in the workbook of all that has a REF reference, I got rid of two of the 3 workbooks that are linked. But one is still remaining.
There really is no link. If an empty workbook is created with the name the link asks for then there is no problem, but this workbook is in Windows\temp which is a folder which I reglary empty. Anyway I want to get rid of this false link that acts like a Ghost in my Excel application. Who can help.