Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Slow opening of "in use" workbook
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 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Slow opening of "in use" workbook
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 "Kurosh" wrote: 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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Running Virus Scan" ....On Opening Excel Workbook | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |