Hi there,
I use excel to produce quotations at work, for which I have a master file that I copy each time I do a new quote. On the master file, I have a hyperlink to another workbook that contains a checklist I want to use. Whenever I create a copy of the master file for a new quote, this link breaks and an error message comes up saying 'Address of this site not valid'.
Can anyone help me figure out how to make this link work across every copy I make of the master file?
Many thanks.
I use excel to produce quotations at work, for which I have a master file that I copy each time I do a new quote. On the master file, I have a hyperlink to another workbook that contains a checklist I want to use. Whenever I create a copy of the master file for a new quote, this link breaks and an error message comes up saying 'Address of this site not valid'.
Can anyone help me figure out how to make this link work across every copy I make of the master file?
Many thanks.