Looking for some help on Microsoft excell 2013 if anyone is able.
I have an excel spreadsheet that contains some stock information. Each line item has a hyperlink to another file on my N.A.S box. All works very well.
What I also need to do is to save a copy of that file on a daily basis, a back-up if you like. I do this by doing a daily back up to the N.A.S box also.
My problem is that the hyperlink will not open in the copy version. It only works in the original.
I have checked the hyperlink properties and the file paths but all are exactly the same but the link will not open in any copy I make.
Have a look this https://support.office.com/en-GB/article/Hyperlinks-in-worksheets-edb15706-517b-4ecf-81c6-84068ff867...
I'll sort it out if you haven't.. PM Me...NEAL