Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
strange problem: excel file does not open and background freezes i EdH Excel Discussion (Misc queries) 2 April 21st 06 02:00 AM
Problem displaying recordsets in Excel Format David Alexander Excel Discussion (Misc queries) 2 February 27th 06 04:52 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Urgent Help Required on Excel Macro Problem Sachin Shah Excel Discussion (Misc queries) 1 August 17th 05 06:26 AM
Problem Opening An Excel file. - by yk ilikecy Excel Discussion (Misc queries) 0 February 4th 05 08:19 AM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"