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

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
JimDataAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ComputerTechieCommented:
set your antivirus software to check on write not on read.

CT
0
JimDataAuthor Commented:
I have turned the antivirus off completely and it has no effect

0
ComputerTechieCommented:
how fast is your data connection?

how much quicker is it on local harddrive?

CT
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

JimDataAuthor Commented:
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
ComputerTechieCommented:
are the files on a compress drive that would slow down the file transfer is there a filewall?

CT
0
JimDataAuthor Commented:
No - brand new dell server w/fast hard drives
0
JimDataAuthor Commented:
Drives are not compressed
0
ComputerTechieCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JimDataAuthor Commented:
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
ComputerTechieCommented:
do the clients have write access the the folder?
this could show down the file opening

CT
 
0
JimDataAuthor Commented:
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
JimDataAuthor Commented:
s
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Server Hardware

From novice to tech pro — start learning today.