Archive of Mr Excel Message Board
Back to Hyperlinks in Excel archive index
Back to archive home
Displaying cells that have links
Posted by TanKS on July 10, 2001 2:02 AM
Hi
Received a couple of huge worksheets. I want to know which cells in one worksheet, has links to the other.
Short of going thru each cell, is there a way to display the cells? Thanks!
Re: Displaying cells that have links
Posted by Malc on July 10, 2001 2:29 AM
If you know what the file name cells are linked to (Look under the edit links menu) you could try highlighting the cells using the conditional formatting option. i.e format cells red that contain ???xls or use Edit Find to find them one at a time. Another idea select the whole worksheet and copy paste secial values to get rid of the lot.
tools_options_general_Checkbox_Formulas. Uncheck when finished
Posted by zen on July 10, 2001 5:16 AM
Re: tools_options_general_Checkbox_Formulas. Uncheck when finished
Posted by TanKS on July 10, 2001 5:48 PM
>> Thanks for the help! It works!
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.