i have a workbook i use as a master. i use it to create about 50 more
workbooks with 30 worksheets. the first page in each workbook have 30 names
that are linked to each worksheet. when i copy the master and change the name
of the file, all the hyperlinks still try to point to the master. is there a
way to only change the workbook the links point to without changeing anything
else in the link.