Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP!
This is what's happening to me. I have 3650 rows so this is not feasible to
type each correctly. Can anyone help? Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel View products that this article applies to. This article was previously published under Q214328 Expand all | Collapse all SYMPTOMS In Microsoft Excel, if you sort a range of cells in a worksheet that contains h... In Microsoft Excel, if you sort a range of cells in a worksheet that contains hyperlinks, the following problems may occur: * Some of the hyperlinks may be removed. Although the blue, underlined text appears in the cell, nothing happens when you click the link. * Some of the hyperlinks may be changed so that they refer to the wrong addresses. For example, a hyperlink that previously referred to one Web page may now refer to a different Web page. Back to the top CAUSE This problem may occur if you copy and paste cells that contain hyperlinks, and... This problem may occur if you copy and paste cells that contain hyperlinks, and then sort the cells. Back to the top RESOLUTION If this problem occurs, manually correct the hyperlinks. To do this, use one of... If this problem occurs, manually correct the hyperlinks. To do this, use one of the following methods: * If Excel has removed the hyperlink from the cell, select the cell and click Hyperlink on the Insert menu. Type the correct address in the Address box, and then click OK. Note If Excel 2007 has removed the hyperlink from the cell, select the cell, and then click Hyperlink in the Links group on the Insert tab. In the Insert Hyperlink dialog box, type the correct address into the Address box, and then click OK. -or- * If the hyperlink refers to the wrong address, right-click the cell, and then click Edit Hyperlink. In the Edit Hyperlink dialog box, correct the address in the Address box, and then click OK. Back to the top STATUS Microsoft has confirmed that this is a problem in the Microsoft products that ar... Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. Back to the top APPLIES TO * Microsoft Office Excel 2003 * Microsoft Excel 2002 Standard Edition * Microsoft Excel 2000 Standard Edition * Microsoft Excel 97 Standard Edition * Microsoft Excel 2004 for Mac * Microsoft Excel X for Mac * Microsoft Excel 2001 for Mac * Microsoft Excel 98 for Macintosh * Microsoft Office Excel 2007 |