• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Links could not be opened

N

neeraj2050

Member
Greetings!!
I have linked my file from other files. But after closing the file and reopening, if I try to open the link, it shows messages that “File could not be opened………………………………”
Again I reestablish the links. But again I face the same situation after reopening it
Thanks in advance!!
Regards
Neeraj Kumar Agarwal
 
1) Have You tried to save Your file before close it?
2) Do those links work ever?
3) How do You reestablish the links?
 
I do save "n" number of times

After reestablishing it works perfectly for a day. And next day again it gets to the same situation

Reestablishing means that I get the links updated again
 
I suspect, linked files are on a network drive and not on local drive.

Hyperlinks are sometimes saved/stored as relative to the folder that contains the workbook with hyperlinks. This can break, if the workbook is moved or when network drives are re-mapped using log-on script (via ADO) etc.

Go to File->Properties and click on "Advanced Properties". Go to Summary tab, and find "Hyperlink base:".

Type "\\ServerX\FolderX" or some other non existent location. This will force hyperlink to use absolute path instead of relative one.
 
You must log in or register to reply here.
Back
Top