Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 74
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Running Virus Scan" ....On Opening Excel Workbook Dermot Excel Discussion (Misc queries) 1 August 30th 07 09:17 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
cannot use "Create List" and "Share Workbook" same time Devendra Excel Discussion (Misc queries) 0 October 26th 06 06:05 AM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"