Hyperlinks

dreinisch

New member
Joined
Sep 9, 2011
Messages
9
Reaction score
0
Points
0
Location
Troy, Missouri, United States
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.
 
As far as I can tell, if you save the template as a new file (i.e. save as, new name) then hyperlinks are updated accordingly. So they reference the new books
 
Back
Top