MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Displaying cells that have links

Posted by TanKS on July 10, 2001 2:02 AM


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!

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.

Posted by zen on July 10, 2001 5:16 AM

tools_options_general_Checkbox_Formulas. Uncheck when finished

Any Help??


Posted by TanKS on July 10, 2001 5:48 PM

Re: tools_options_general_Checkbox_Formulas. Uncheck when finished

>> Thanks for the help! It works!