Hyperlinks

Is there a way to set hyperlinks to remain linked to its own spreadsheet? Meaning if a template is created which contains hyperlinks to other areas of that same spreadsheet, then I want to copy that template and create a new spreadsheet out of it - how could I ensure the hyperlinks on the new spreadsheet will function within the new spreadsheet rather than take me back to the template? The only way I have found to correct that is to open each hyperlink and refit it to the new spreadsheet one at a time.

It depends how you have set up the hyperlink, but if you have used the HYPERLINK function in a formula, then you would have something like this:

=HYPERLINK("#Sheet2!C3","click me")

and the # symbol in the destination address effectively means "in this workbook", so this would enable you to do what you describe.

Hope this helps.

Pete