breaking links

  1. A

    Break and Color External Links at once

    Excel friends, I have a workbook with one sheet with about 2000 external links. I would like to break all the links and simultaneously make the fond dark blue of each broken link. I found this code and it breaks the links of the whole workbook in a fraction of a second. Is there a way to also...
  2. TinaP

    Cannot break link

    I have a workbook that is showing a link to a temporary file which is no longer there. The link should not exist and was created automatically by MS when the file was emailed. I think. I deleted all of the references to the temporary file from the Name Manager (there were five), but the link...
  3. W

    breaking external links in excel 2007 without keeping data

    I am running Excel 2007 in Windows XP.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I would like to have an xlsx file with data and an xlsx file for the user that is linked to the data. What I need to happen for security reasons is that if...

Some videos you may like

This Week's Hot Topics