Simultaneous user question
 

Hello -

I have 30 users that need to be able to access a project at the same time.
The project has user forms. Are there any problems I should be aware of?
Does it work similar to Access?

Any help will be greatly appreciated!
--
Sandy

Simultaneous user question
 

No it's similar to Access. An Excel workbook is not a multi-user beast. The
main problem you need to be aware of is that it won't work.



"Sandy" wrote in message
...
Hello -

I have 30 users that need to be able to access a project at the same time.
The project has user forms. Are there any problems I should be aware of?
Does it work similar to Access?

Any help will be greatly appreciated!
--
Sandy

Simultaneous user question
 

That seems a very confusing response to me.

Sandy,

You can setup a workbook as shared, and this will allow multiple users to
open it with update access. You have the same problems of concurrent
updates, but I believe that Excel will ask if your update is to overwrite a
previous. Also, with shared workbooks, many functions are disabled.

In general, unless you are happy with the limitations, and if you can rest
assured that each user will update a separate area of the workbook, shared
workbooks are not a good idea. Excel was not really designed for this, and
there are better tools, such as Access.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jezebel" wrote in message
...
No it's similar to Access. An Excel workbook is not a multi-user beast.
The
main problem you need to be aware of is that it won't work.



"Sandy" wrote in message
...
Hello -

I have 30 users that need to be able to access a project at the same
time.
The project has user forms. Are there any problems I should be aware
of?
Does it work similar to Access?

Any help will be greatly appreciated!
--
Sandy

Simultaneous user question
 

Perfect IT answer. It won't do what you want, but let's redefine the
requirements so we can claim success anyway.

As you confirmed, it won't do what the OP wants. In other words, it won't
work.



"Bob Phillips" wrote in message
...
No, you said it won't work. I said it will work with limitations, but I
wouldn't recommend it. Pompous or not, that doesn't seem like the same
thing
to me.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
That seems a very confusing response to me.

Sandy,

You can setup a workbook as shared, and this will allow multiple users to
open it with update access. You have the same problems of concurrent
updates, but I believe that Excel will ask if your update is to overwrite
a
previous. Also, with shared workbooks, many functions are disabled.

In general, unless you are happy with the limitations, and if you can
rest
assured that each user will update a separate area of the workbook,
shared
workbooks are not a good idea. Excel was not really designed for this,
and
there are better tools, such as Access.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jezebel" wrote in message
...
No it's similar to Access. An Excel workbook is not a multi-user beast.
The
main problem you need to be aware of is that it won't work.



"Sandy" wrote in message
...
Hello -

I have 30 users that need to be able to access a project at the same
time.
The project has user forms. Are there any problems I should be aware
of?
Does it work similar to Access?

Any help will be greatly appreciated!
--
Sandy

Simultaneous user question
 

whatever


"Jezebel" wrote in message
...
Perfect IT answer. It won't do what you want, but let's redefine the
requirements so we can claim success anyway.

As you confirmed, it won't do what the OP wants. In other words, it won't
work.



"Bob Phillips" wrote in message
...
No, you said it won't work. I said it will work with limitations, but I
wouldn't recommend it. Pompous or not, that doesn't seem like the same
thing
to me.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" wrote in message
...
That seems a very confusing response to me.

Sandy,

You can setup a workbook as shared, and this will allow multiple users
to
open it with update access. You have the same problems of concurrent
updates, but I believe that Excel will ask if your update is to
overwrite
a
previous. Also, with shared workbooks, many functions are disabled.

In general, unless you are happy with the limitations, and if you can
rest
assured that each user will update a separate area of the workbook,
shared
workbooks are not a good idea. Excel was not really designed for this,
and
there are better tools, such as Access.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jezebel" wrote in message
...
No it's similar to Access. An Excel workbook is not a multi-user
beast.
The
main problem you need to be aware of is that it won't work.



"Sandy" wrote in message
...
Hello -

I have 30 users that need to be able to access a project at the
same
time.
The project has user forms. Are there any problems I should be
aware
of?
Does it work similar to Access?

Any help will be greatly appreciated!
--
Sandy

Simultaneous user question
 

To All -

Thanks for the replies. Guess I need to find someone who has actually
implemented this.

I have a project that does not lend itself to Access - it's more of a
spreadsheet/word type of project. I was happy to learn that Excel projects
can be shared, but now I'm wondering if I should take a chance with it. I
can live with the limitations, however if it's going to cause network
problems or be too slow, I don't know . . .
--
Sandy


"Sandy" wrote:

Hello -

I have 30 users that need to be able to access a project at the same time.
The project has user forms. Are there any problems I should be aware of?
Does it work similar to Access?

Any help will be greatly appreciated!
--
Sandy