Links between workbooks
Posted on 2011-05-06
I've noticed that from time to time I'll open a workbook and find it comes up with something like "This workbook is linked to another one, do you want to update the linked values?" However I never deliberately link workbooks, so these links have got there accidentally. The link is easily broken, but it shouldn't have been there in the first place.
Can anyone tell me how this could happen? I'd like to know so that whatever it is, I don't do it. I suspect it must have something to do with copy and paste from one workbook to another, but I often do that and suspect if this is the cause then it doesn't always create a link, and I wonder why.