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

  • Thread starter Thread starter JTD
  • Start date Start date
J

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?
 
Hi

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