strange problem with links updates in excel
 

hi,
i run fileserwer on which i've got excel worksheets with links to other
excel sheets. i've got several users, who work on that files. the
problem is:updating links take about 2sec on one computer, 30sec on
dffrent one (with more or less the same hardware configuration) and
90sec on another one (hardware is a bit slower here, but not much). i'm
using ms office xp SBE patched with office-sp3 on all computers
(without that patch updating links is even slower).
basically: it's not a problem in worksheets (than it'd be slow on all
computers), it's not also a problem with network connection (i have
fast transfers when i normal copy files from serwer into workstations,
besides - i see that excel takes 100% of cpu during that updates, so
it's definitly not waiting for data) and it's not problem with office
release (since i use the same version on each workstation).
i'm pretty out of ideas what can be wrong.. maybe something with
office's configuration? or maybe someting in windows?

strange problem with links updates in excel
 

A guess would be that the 30 sec computer has an access to the files
that is very slightly longer (ie, routed through one more step, or is
set to Full/Half duplex instead of Full/Full, virus scanning does/does
not include network files etc) than the 2 sec version.

If you time-trial a 50 mb file read and save, do you also notice the
same ratio for speed ?

--

Wrote:
hi,
i run fileserwer on which i've got excel worksheets with links to
other
excel sheets. i've got several users, who work on that files. the
problem is:updating links take about 2sec on one computer, 30sec on
dffrent one (with more or less the same hardware configuration) and
90sec on another one (hardware is a bit slower here, but not much).
i'm
using ms office xp SBE patched with office-sp3 on all computers
(without that patch updating links is even slower).
basically: it's not a problem in worksheets (than it'd be slow on all
computers), it's not also a problem with network connection (i have
fast transfers when i normal copy files from serwer into workstations,
besides - i see that excel takes 100% of cpu during that updates, so
it's definitly not waiting for data) and it's not problem with office
release (since i use the same version on each workstation).
i'm pretty out of ideas what can be wrong.. maybe something with
office's configuration? or maybe someting in windows?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535201