ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multi-use with excel 97 possible?? (https://www.excelbanter.com/excel-discussion-misc-queries/65261-multi-use-excel-97-possible.html)

Kuwerti

Multi-use with excel 97 possible??
 
Hello all,

I have an excel 97 worksheet. It must be possible that several people
can work at the same time in this sheet. Is this possible?? Or do I
need something else to arrange this?

Thanks and Regards,
Anneke


Dave Peterson

Multi-use with excel 97 possible??
 
You can share the workbook (tools|share) (well, if it's stored in a central
location that all can get to).

But there's lots of things that can't be done with shared workbooks. See
Excel's help for details.

Personally, I try to just let one user work on the workbook at a time.

There are other applications that may be better--maybe a real database program
(Access???).

Kuwerti wrote:

Hello all,

I have an excel 97 worksheet. It must be possible that several people
can work at the same time in this sheet. Is this possible?? Or do I
need something else to arrange this?

Thanks and Regards,
Anneke


--

Dave Peterson

Bill Martin

Multi-use with excel 97 possible??
 
Kuwerti wrote:
Hello all,

I have an excel 97 worksheet. It must be possible that several people
can work at the same time in this sheet. Is this possible?? Or do I
need something else to arrange this?

Thanks and Regards,
Anneke


You can probably share it in Read Only mode. You can't have multiple people
writing into it at the same time though and expect to not lose data. The idea
of letting multiple people R/W something at the same time is a database concept,
not one built into a spreadsheet.

Bill


All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com