Linking spreadsheets
 

I have multiple spreadsheets that aer linked to one big one. All the sheets
reside on the server in the same folder. On some of the links the address
area has ='[folder name]filename'!$c$22 and on other links the address area
says ='\\server name\main folder\sub folder\sub folder\sub folder\[folder
name]filename'!$c$22

All the spreadsheets are open, but the one with the server anme and all the
subfolders takes for ever to update and the one that recognizes that the
files are in the same place updates in seconds.

Any idea how to fix this issue.

Thanks