Hi Laura
For waht its worth Chris D is on the money correct follow him, i chat to Chris a few times on email hes been on about links ever since i have klnow him, his A1 delete me trick works.
I tend to highlight (show) all the links / formulas and have a look manually and hunt the terror down.
I fine that Vlooks are a colprit as the dont update if you arcvive a months finance details and the Vlookup was linked to data sheet all goes horribly wrong.
I have MASSIVE sheets will billions of fromulas and cells of data and i know the woorkbooks inside out back wards and standing on my head wareing a blind fold playing the drumbs and srtrumming the violin! but all sheets need and require careful daily maintance so you / i the opperator should know the where what at a snap..
Edit and links will shows all linked data so can edit or remove or whatever....
Would be my other suggestion -
Hot tip ---- i have a sheet called test which i have many bizzar formula VBA codes and so on all tests so why not assign a reange to house links data and protect them cells just in cae you delete them them you have record ao all links and where they are should you need to refer to them
In Test sheet i have hundreda of formulas i have written so i can reuse them,,, all VBA i have also i sheet VBA so i can add them as needs be...
So thought
HTH
Rdgs
==========
Jack