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 -- ---------------------------------------------------------------------------------- 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.
