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

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

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

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