[Linked Excel file not accessible from shared Excel file on server]

hi pete

One more problem i am facing in microsoft excel i have created one excel file and in that file i have linked another excel file. I have shared that excel file on file server. When client computer try to access that file, the file is opening but another file which i have linked is not opening. On some systems its opening but on other systems its not opening .System configuration is same as above. I hope you try to understand what i mean to say

 

hi Pete,

Yes both the files are on same server

 

Check that the link path is not local. That is, it is not something like:

Code:

'[C:\directory\file_name.xls]Sheet1'!$B$38

If the file being linked to is not in the same location as the file being opened, then the link should be the full network URL (in fact its probably better to always ensure it is the full URL). That is something like this:

Code:

'[\\server_name\share_name\directory\file_name.xls]Sheet1'!$A$1

By the way - linked spreadsheet are very difficult to maintain in a shared environment. Are you sure you need to link the sheets? There is usually a better way to handle the problem. For example by using hidden sheets or a shared database.