Software

Ask something
Discussion Locked

Canceling Links in a Workbook

0 helpful
6 replies

by ljackson.desoto

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a workbook that was once linked to another and now every time the workbook opens it asks if I want to update links. I have gone into edit/links but cannot find a way to delete the link. Is there a way to cancel all links and keep the data that is currently there. Thank you.

6 replies

by larryjc

Try this:

Select all the cells with the link, copy to the clipboard and then paste it as values (paste especial).

Note that you only can copy adjacents cells.

If there are too much linked cells dispersed in the workbook, use edit-find and search for the linked file path....

I hope it works for U
Regards,
Larry

This discussion is closed to new replies.