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?
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:
gt; hi,
gt; i run fileserwer on which i've got excel worksheets with links to
gt; other
gt; excel sheets. i've got several users, who work on that files. the
gt; problem is:updating links take about 2sec on one computer, 30sec on
gt; dffrent one (with more or less the same hardware configuration) and
gt; 90sec on another one (hardware is a bit slower here, but not much).
gt; i'm
gt; using ms office xp SBE patched with office-sp3 on all computers
gt; (without that patch updating links is even slower).
gt; basically: it's not a problem in worksheets (than it'd be slow on all
gt; computers), it's not also a problem with network connection (i have
gt; fast transfers when i normal copy files from serwer into workstations,
gt; besides - i see that excel takes 100% of cpu during that updates, so
gt; it's definitly not waiting for data) and it's not problem with office
gt; release (since i use the same version on each workstation).
gt; i'm pretty out of ideas what can be wrong.. maybe something with
gt; office's configuration? or maybe someting in windows?--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=535201
- Aug 28 Tue 2007 20:39
strange problem with links updates in excel
close
全站熱搜
留言列表
發表留言