Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-07-09
12
Medium Priority
?
280 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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 1000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

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.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

604 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