Links in excel (1 Viewer)

gmit

Registered User.
Local time
Today, 21:03
Joined
Jan 27, 2004
Messages
23
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

Registered User.
Local time
Today, 16:03
Joined
Mar 25, 2002
Messages
516
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.
________
BUY NO2 VAPORIZER
 
Last edited:

Users who are viewing this thread

Top Bottom