Unable to Break Links to another file
Last week I copied a worksheet from one spreadsheet into another, and have since been working from the new one. When I open the file I get a message box asking if I want to Update links from the other workbook. But I've deleted all named ranges, formulae, shapes, everything that could possibly link to the other workbook. I've also (in my frustration) completely deleted the sheet that was originally copied and re-made it from scratch. But it STILL comes up with this update box. In Excel's Help it says to go to Edit/Links and press Break Link, which I have tried but it doesn't do a thing. The link is still sitting there in the display box in the Links window - it says that the Type is Worksheet, I don't know if this makes any difference that it's not a formula or anything?
Also, in complete desperation when it wasn't deleting the link, I changed the source to a random file, so it now comes up with an error in updating (which it obviously would) however this doesn't have any effect on my file because as far as I can tell it no longer has links to the other file!
I'm tempted to just go to the option that says don't show the Update prompt on opening (the file is to be handed in as coursework on Wednesday) but this doesn't solve the problem, only bypasses it!
Each time I made a major change (e.g. recreating the copied worksheet, changing the source) I saved the file under a different name, so I have all old copies just incase I've completely messed it up!
Any ideas what this link is up to?
Video Tutorials / Excel Dashboards Reports