Where does it tell you which cell contains the link? I've run a search on the entire workbook and I don't think the link actually exists.
On Mar 18, 12:08 pm, Michael <michaelmug...@gmail.com> wrote: > It should tell you which cell contains the link. Go to it and delete > it. You will need to hard code the data. > > On Mar 17, 3:31 pm, "~slacker~" <mbarl...@gmail.com> wrote: > > > > > I need help in breaking data links to other excel workbooks. The excel > > workbook I am using (excel 2007) has links to other workbooks that can > > been seen by going to Data -> Edit Links > > One of the links listed here does not point to a valid workbook and I > > would like to break the link to get rid of the "Continue or Edit > > Links" prompt that occurs when opening this workbook. > > Using the "Break Link" button does not work as the link does not > > appear to have a valid location. > > > Is there another way to break links in a workbook? > > > thanks in advance- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.