Forum Discussion
Excel automatically and randomly changes workbook relative links to absolute links.
Hi everyone, I am working with sevral large workbooks that are linked together (total over 110 Mb of data). Periodically, I do backups trying to copy all workbooks together to another drive hopin...
Thank you Patrick2788 for your answer. When you mention broken links, do you consider a link that starts (in a VLOOKUP formula for example) with "file:///D:..." as a broken link ? If so, are you aware of any possible solution to fix those links ?
Thank you MickThornton for all your input as well !
Thank you MickThornton for all your input as well !
'broken' being - you click the link and get an error that says something like file could not be opened. Direct hyperlinks to files on the network and internet has been an issue for a long time.