Hyperlink help! Copies point to wrong workbook (sometimes!)

[JTD]

I have a workbook with internal hyperlinks to other parts of the
workbook. The workbook is saved as c:\\Documents and Settings\ AAA (for
example) and all the internal hyperlink paths are Documents and
Settings\AAA\sheet name and cell. When I make a copy of the workbook
and name it BBB some of the hyperlinks change the path automaticaly to
c:\Documents and Settings\BBB\sheet name and cell(like they are suposed
to I thought) but some still point to the AAA workbook (C:\Documents
and Settings\AAA\sheet name and cell. Why is that and how can I fix it
so when I make a copy with hyperlinks that are internal to the
workbook, ALL the links are updated to reflect the name of the new
workbook?

 

[Arvi Laanemets]

Hi

Did you copy (rename) in explorer window, or you used SaveAs in Excel - the
end result may depend on method.

 

[JTD]

I used Save As in the Excel menu.