M
munish
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.
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.