I have a excel 2007 file(macro enabled) linked with 20 difefrent excel 2007
file (some of them macro enabled). Whenever I am enabling external links to
get updated figures from linked files, only half of the links are updating
rest will show an error in source file. I have to source again to same files
at same location. files with error in source could be same file or any
different file each time I am trying to refersh links.

I have never changed any file locations and file name but this happes every
time.

I am working in a office with Novel network with xp on all machines, this is
a trouble because we need to update the master file at least 10 times in a
day and at present every time we ahve to source 10 files. Waste of time,
never happended with 2003 version.

Any suggestions are welcomed.
--
munish