Solved

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

Posted on 2009-07-09
12
275 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
  • 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Patch Management is administrated by page 129 of  the following document:     http://support.dell.com/support/edocs/software/smdmc/11/en/ug/ug.pdf However, there are issues with Patch Management with FTP (for instance, a slow Internet connectio…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 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