I think the problem may be that you are saving the active workbook  with a
different name - the equivalent of Save As. You could try copying the file
before opening and making the changes. I think this way the file will maintain
"internal" links.