Workbook is linked to a file that was deleted.

G

Guest

My workbook has a link to a file that was deleted. I try to remove the link
but it says that the source is locked, but I can't find the source because it
was deleted. When I try to copy it in a different way, it still copies the
formula with the link. What can I do?
 
B

Bill Manville

Are you sure it isn't the cell containing the formula that is locked
and the worksheet protected - in that case you can't change the content
of the cell.

Bill Manville
MVP - Microsoft Excel, Oxford, England
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top