I have nearly around 200 hyper-links in my excel sheet and casually all the hyper-links were automatically stopped from working and the exact path has changed, can you please provide me with a solution? thanks in advance,
Is this for files? Sounds like the file structure of where they are stored has changed. Effectively have the files moved location?
Yes, the file structure has been changed. For example, at the first time i created the hyperlink for some files in D drive so that when you were clicking the specified cell it was directly taking you the D.../... , but the "path" has been changed from D to C and i don't know what is the problem? in addition, it is not only 1 hyperlink that's corrupted, all the other hyperlinks have the same issue. Hope it is clear