When I copy a worksheet to a new book excel removes part of the hyperlink
directory tree from each hyperlink rendering them useless (the change is
identicle for all the links). Am I doing something wrong?