It depends on what your hyperlink contains. For instance a hyperlink
to http://www.google.com should remain the same.

A hyperlink to sheet22!B5 is going to give you trouble if you copy sheet to
a new workbook and a problem with how we would know what you really wanted.

The safest way is to copy the entire worksheet making a copy.
Edit, Move or copy sheet, make sure you check make a copy.

Excel will include the workbook name when it is copied to a new workbook.
You can only have one workbook with a name i.e. TimeSheet.xls
open at one time. You may be picking up the pathname as well or not
picking up the pathname causing a problem. Look in that area for
problems, between what you see and the hyperlink.
---
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

"Thomson health care" wrote in message
...
Can you copy a cell and place that cell in a new spread sheet that has a
hyperlink and still expect the hyperlink to work? I have tried it several
times and have always recieved an error message. I have not changed anything
other than palce the copied cell that has the working hyperlink in a new
workbook.