Multiple Users in Workbook at the same time 1

[kabushnell]

I am wondering if there is a way to set up a workbook to allow multiple users to be able to make changes simultaneously. I know you can open as read-only if you open a workbook that someone else is using. I am just wondering if there is a way to set this up because I have a worksheet that is updated by several users and they are running into problems because the other users are in the workbook at the same time.

Thanks

 

[SkipVought]

Hi,

Take a look at workbook sharing.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[xlbo]

And then disregard it as it is horrible to work with. ;-)
IMHO, if you want a nice simple multi user app, go for Access

Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question

 

[gizmo1973]

I was waiting for that!

Regards, Phil.
C.E.O. Bodgeit, Leggit & Scarper. International.
"Stuffing things up completely since 1973"

 

[xlbo]

I'm going to keep re-iterating it as I honestly believe that the "Sahre Workbook" option in excel is so bad that M$ should bin it. I have yet to see or hear about a single project using a shared workbook that works as it was intended and that the users are happy with!

Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

DITTO!

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[gizmo1973]

Even mine broke recently after Geoffs previous warnings!
Is it the XLBO curse.
I won't be using them again!

Regards, Phil.
C.E.O. Bodgeit, Leggit & Scarper. International.
"Stuffing things up completely since 1973"

 

[munkee35]

We use a shared workbook to keep tabs on our company credit card expenditure; no problems so far )

 

[xlbo]

File bloating ??
Users making changes but then having them overwritten as there is no hierarchy system for which should be implemented when conflicting changes are made??
Workbook corruption ??
Can't make changes to macros whilst in share mode ??

Any more for any more ?


Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question