Read / Write Access

[Please HELP!!!]

We have a file that is not "Shared" but that 5 or 6 of us make changes to one
at a time. Therefore, only one of us will have write access at any given
time. Normally, when another user attempts to open the file while someone
has write access they will receive the warning message and be forced to open
a read-only version. However, we have recently switched to 2003 and this
seems to be sporadic now and we can't determine a cause.

We have checked all of the sharing and authorizations with our IT dept. and
everything seems to be set correctly. However, we are continually running
into instances where two users have write-access. Any idea what could be
causing this sharing / access issue??

 

[Jan Karel Pieterse]

Hi Please,

We have checked all of the sharing and authorizations with our IT dept. and
everything seems to be set correctly. However, we are continually running
into instances where two users have write-access. Any idea what could be
causing this sharing / access issue??

Sorry for asking the obvious, but have you double checked the Tools, share
workbook settings?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Please HELP!!!]

Thanks, Jan - yes we have. It is not set to allow multiple users.

Brian

 

[Jan Karel Pieterse]

Hi Brian,

Thanks, Jan - yes we have. It is not set to allow multiple users.

OK, I have searched Google and found you're not alone:

http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/c1
93e5fc8bc1e19/55d3a22c6ab23fdf?lnk=st&q=excel+2003+workbook+not+readonly&rnum=6#55
d3a22c6ab23fdf

http://groups.google.com/group/microsoft.public.office.misc/browse_thread/thread/3
39d973cd9ba7d69/97df6d7121787c92?lnk=st&q=excel+2003+no+%22File+In+Use%22+message&
rnum=4#97df6d7121787c92

I'm going to escalate this question to MSFT.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Please HELP!!!]

Hi Jan,

Have you received any further response or information related to this
problem?

Thanks!

Brian

 

[Jan Karel Pieterse]

Hi Please,

Have you received any further response or information related to this
problem?

Nope, still waiting for a response from msft.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com