View Full Version : Links in excel


gmit
12-03-2005, 05:47 AM
Hi
Can anyone tell me how you can view links in Excel?
We use a large spreadsheet at work that contains cells that link to other excel documents. Some of these links are incorrect and want to be removed. Is there any way of checking which cell links to which document without selecting the cell.
Thanks.
George.

shades
12-03-2005, 10:09 AM
Howdy. On the menu bar go to Edit > Links. In the resulting dilaog box, it will show the links on the left. You can select all (click first then scroll to bottom and SHIFT-CLICK) and then on the right, click the "Break Link" button.