Slow opening of "in use" workbook

[Guest]

Hi,

I have a client who is sharing Excel 2003 files on a peer-to-peer network,
on a Windows Vista Home machine. They had a problem with opening files in
general, which I traced to some issue with Norton Internet Security 2007 on
the "server"; I excluded Auto-Protect from those directories, and that seemed
to resolve it. Now, I understand they are having a problem when an Excel
file is already open by one user, it takes a really long time (not sure how
long yet) for someone else who tries to open it before they get prompted that
it's already open (and gives them the choice to open it read-only, etc.).
Any suggestions as to why?

I have come across other posts in here re: how to share workbooks (and
advice not to do that)... but that's not what they intend to do. They just
want to have that prompt that the file is in use appear much quicker.

Best Wishes,
Kurosh

 

[Guest]

It could be one of many different issues. The most likely one being the
configuation of the network. Shared files running slowly is rarly, if fact
I've never hear of it, being the cause of an issue of the file itself. Most
likely it is how the computers are linked to the server, where the file is
located (on the server, or on a compter linked to server), or it could be
bandwidth. I would need to see your settings and configuation to tell you
more, sorry.
--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009