Solved

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

Posted on 2009-07-09
12
276 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
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.

 

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

The 6120xp switches seem to have a bug when you create a fiber port channel when you have a UCS fabric interconnects talking to them.  If you follow the Cisco guide for the UCS, the FC Port channel will never come up and it will say that there are n…
More or less everybody in the IT market understands the basics of Networking, however when we start talking about Storage Networks, things get a bit dizzier, and this is where I would like to help.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 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