Breaking Links

Could anyone tell me if it is possible to break a link from one workbook to another workbook that has been deleted? If so, how can I do it? I am using Excel for Mac 2004.
Thanks,

Don

Originally Posted by drltr6

Could anyone tell me if it is possible to break a link from one workbook to another workbook that has been deleted? If so, how can I do it? I am using Excel for Mac 2004.
Thanks,

Don

When opening the file, and when you receive the warning about the file containing links, (even though the linked file has been deleted), choose 'Edit Links', and then 'Break Links'. All linking formula will then be converted to values.

Rgds