There might be a couple of reasons that these spectres are still haunting your workbooks so let’s look a few ways you can hunt down and exorcise these spooky apparitions from your models once and for all. So you delete it again but it’s still there! Try as you might, it simply won’t delete. You look into Edit Links on the Data Tab (as shown in Figure 1), and sure enough, there’s a link in there, even though you already deleted it. When you open the file, it asks you to update links. Usually this happens with models that have been in use for a while and that we have inherited from someone else, but sometimes it happens to your models that you’ve built yourself. Happy Halloween! I have been meaning to write about phantom links for a while, and Halloween is a good time to talk about hunting down and exorcise this ghoulishly annoying phenomenon from your financial models.Īlthough not exactly spine-tinglingly terrifying as formula errors, for example, any modeller who has been working with Excel for any length of time has probably come across the experience of being unable to delete external links.
0 kommentar(er)
