Johnwrote:
Any ideas why the macro won't do it?

ActiveWorkbook.BreakLink Name:= _
"\\Porfs01\snt\Taxable\Research &
Inventory\Inventory\SNW INV
PLAIN.xls", Type _
:=xlExcelLinks

Thanks for the help!
Excel is unlikely to break links when any cell or named area contains
a link. Review Named areas which might show what's going on.