Workbook is linked to a file that was deleted.

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top