Network Access For Excel

RoyinUK2000 · Apr 2nd, 2002, 07:07 AM

If I want to run a workbook in Excel and give several users access to the same file. Is there a way I can get Excel to stop the file opening if someone else already has write access to the file, possibly with a message like "Busy....Try again later".

Don't know if this is possible but one way to find out is to ask you guys

Thx Roy

GeorgeB · Apr 2nd, 2002, 07:22 AM

Hi RoyinUK2000
Any network I have ever been on allows only one person at a time to use Excel unless it is set up in shared mode. Otherwise it can be opened in "Read only" condition by any one else.
George

RoyinUK2000 · Apr 2nd, 2002, 07:34 AM

I know this, what I am asking is can I stop a workbook opening if it is going to be opened in read only mode, i would rather a user not be able to get into the workbook than get into it in read only mode.

Don't know if this is possible

Thx
Roy

Jack in the UK · Apr 2nd, 2002, 11:14 AM

H

The data given is dafult Excel.. one live the others read only and can choose notify.. this is security...

BUT...

why not if restriction Mr A and B c d no access set a token ribg to secure the Folder the Doc lives in.. if stuck speak wit hthe IT dept thay can set this in 5 seconds flat and password protect..... simple as that..

I have done this billions of times, you might need grouping access details to be amended under armagedon (whatever network you have)

IT dept wont resist this if they do then they have not go a clue how to set networks inside network???

HTH

Apr 2nd, 2002, 07:22 AM	#2
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Hi RoyinUK2000 Any network I have ever been on allows only one person at a time to use Excel unless it is set up in shared mode. Otherwise it can be opened in "Read only" condition by any one else. George __________________ George Learn to listen. Opportunity sometimes knocks very softly.

Apr 2nd, 2002, 11:14 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	H The data given is dafult Excel.. one live the others read only and can choose notify.. this is security... BUT... why not if restriction Mr A and B c d no access set a token ribg to secure the Folder the Doc lives in.. if stuck speak wit hthe IT dept thay can set this in 5 seconds flat and password protect..... simple as that.. I have done this billions of times, you might need grouping access details to be amended under armagedon (whatever network you have) IT dept wont resist this if they do then they have not go a clue how to set networks inside network??? HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 07:07 AM	#1
RoyinUK2000 Board Regular Join Date: Mar 2002 Posts: 79	If I want to run a workbook in Excel and give several users access to the same file. Is there a way I can get Excel to stop the file opening if someone else already has write access to the file, possibly with a message like "Busy....Try again later". Don't know if this is possible but one way to find out is to ask you guys Thx Roy

Apr 2nd, 2002, 07:34 AM	#3
RoyinUK2000 Board Regular Join Date: Mar 2002 Posts: 79	I know this, what I am asking is can I stop a workbook opening if it is going to be opened in read only mode, i would rather a user not be able to get into the workbook than get into it in read only mode. Don't know if this is possible Thx Roy