Can I copy a workbook containing hyperlink bookmarks and have those
hyperlinks refer to cells in the new workbook?

Instead of copying, do a SAVE AS. I had the same question a while back, and
this is the solution.

Carole O

"MiaCat" wrote:

Can I copy a workbook containing hyperlink bookmarks and have those
hyperlinks refer to cells in the new workbook?

Another consideration would be if you were using HYPERLINK Worksheet Function
you might have them within double quotes and they would not change.
You can write them so that they work. See
http://www.mvps.org/dmcritchie/excel/sheets.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Carole O" wrote in message ...
Instead of copying, do a SAVE AS. I had the same question a while back, and
this is the solution.

Carole O

"MiaCat" wrote:

Can I copy a workbook containing hyperlink bookmarks and have those
hyperlinks refer to cells in the new workbook?