We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

JimData
JimData asked
on
Medium Priority
293 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
Comment
Watch Question

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

CT

Author

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

how fast is your data connection?

how much quicker is it on local harddrive?

CT

Author

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.

are the files on a compress drive that would slow down the file transfer is there a filewall?

CT

Author

Commented:
No - brand new dell server w/fast hard drives

Author

Commented:
Drives are not compressed
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

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.
do the clients have write access the the folder?
this could show down the file opening

CT
 

Author

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.

Author

Commented:
s
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.