Not entirely sure about this, but you may want to ensure that these are both
stored in standard folders  (and not enhanced folders).... I've been led to
believe that these act the same as a shared network folder.

They are definitely not enhanced folders. The problem seems to be
that the files are now stored in a web  based system  and have to show
the full path to recognise the file. It is very frustrating. Thanks
anyway. I will keep plugging away!

All documentation on SPS confirms that it doesn't support what are referred
to as 'compound' files i.e. files with links  to other files in enhanced
folders. I have found that linked excel  files produce some surprising
(read: usually annoying and painful) results in SPS, and I don't recommend
them to my users. Put them in standard folders, and if you need to publish
them publish them in the enhanced folders  with the links removed.

The confusing thing is that they are in standard folders  already and
it only seems to be effecting some files, not all. I think the
probelm may lie in the way they have been linked.

Thank you all for your suggestions. I will let you know if I get to
the bottom of it.

I ran into a similar problem. I had multiple Excel files linked together, but only select formulas were not updating. I found that one file was trying to reference a combination of the SharePoint site and the old network folder structure. It was like it created it's own link (very strange). Looking into more I found and obscure formula with and old link that was over looked. Fixing this fixed all my other problems.

Had this happen in two different circumstances too. It appears that for some reason one incorrect formula/link can mess with everything else.

Hope this helps.

Hi. Has anyone found the solution to this problem? I'm really battling to fix it. I would really appreciate help.

Hi. Has anyone found the solution to this problem? I'm really battling to fix it. I would really appreciate help.