Solved

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

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

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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now