Hello all,
I have a workbook that for some reason loses the link to another excel document. It does not happen all the time just sometimes i open the book up and bam its forgotten where the file was located. Not only that it thinks the file is stored somewhere completely different and changes the links in the formula! I then have to change the source back to where the file is. this file its looking for never moves as its used by multiple departments.
What can i do to stop this i'm wasting 30 mins every time it happens just waiting for it to change the source in the formulas.
I have a workbook that for some reason loses the link to another excel document. It does not happen all the time just sometimes i open the book up and bam its forgotten where the file was located. Not only that it thinks the file is stored somewhere completely different and changes the links in the formula! I then have to change the source back to where the file is. this file its looking for never moves as its used by multiple departments.
What can i do to stop this i'm wasting 30 mins every time it happens just waiting for it to change the source in the formulas.
