Solved

Excel /PDFopens file but 10 second delay before you can do anything

Posted on 2009-07-09
12
277 Views
Last Modified: 2012-05-07
When I open an excel file over the network, the file opens up but I can't click any of the columns/cells until appox 10 seconds later.  Very annoying - happenning on all pc's w/different antivirus - also tried shutting off antivirus on server temporarily.  Same files run from c drive open instantly - files are not very big (1 sheet, w/500 values).   PDF's open slow too.  
Help
0
Comment
Question by:JimData
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 23

Expert Comment

by:ComputerTechie
ID: 24819454
set your antivirus software to check on write not on read.

CT
0
 

Author Comment

by:JimData
ID: 24824065
I have turned the antivirus off completely and it has no effect

0
 
LVL 23

Expert Comment

by:ComputerTechie
ID: 24824505
how fast is your data connection?

how much quicker is it on local harddrive?

CT
0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 

Author Comment

by:JimData
ID: 24824894
100 MB

Local hard drive - approx 1-2 seconds

I setup a bat file that copies the file from the server to the local hard drive then opens it.  It takes approx 2-3 seconds.

0
 
LVL 23

Expert Comment

by:ComputerTechie
ID: 24824978
are the files on a compress drive that would slow down the file transfer is there a filewall?

CT
0
 

Author Comment

by:JimData
ID: 24825270
No - brand new dell server w/fast hard drives
0
 

Author Comment

by:JimData
ID: 24825273
Drives are not compressed
0
 
LVL 23

Accepted Solution

by:
ComputerTechie earned 500 total points
ID: 24826845
i was was thing how quick is a data transfer?

for example if you play a movie clip on the server or copy a large file from the server.

CT
0
 

Author Comment

by:JimData
ID: 24827166
I wrote a bat job that copies the file from the server to the local hard drive then opens it up.  So the transfer is very quick - less than 1 second.  This takes 2-3 seconds. When excel on the client pc requests the file from the server, it takes 10 seconds.  This is repeatable across other client pc's.
0
 
LVL 23

Expert Comment

by:ComputerTechie
ID: 24827231
do the clients have write access the the folder?
this could show down the file opening

CT
 
0
 

Author Comment

by:JimData
ID: 24827453
Yes - client can write to the folder.  They can open the file and save it from the shared folder.  The only problem is the time to open and make the file ready for changes.

0
 

Author Closing Comment

by:JimData
ID: 31601853
s
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Requirements: root access via SSH, telnet, or other.. Alternately, access from the server administrator to run a counter-strike server, and the proper access rights to do so. Enough free disk space (and allowed to use this much, eg disk quota): 6…
Usually shares are where we want them for our users and we tend to take them for granted. There are times, however, when those shares may disappear causing difficulty for your users. One of the first things to try is searching for files that shou…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question