Hi All. One that's really stumped me. We have a file that links to other files. There is a formula on one of the sheets and for some reason even when the linked file is deleted it does the following. Says that there is an error and the source is not found but still showing the data from the file even though it's been deleted from the folder. The macro works so that if it comes back as a Ref it knows it's missing and tells you so. Any ideas?