Editing a shared spreadsheet simultaneously

[Guest]

We are currently networked using Excel 2000. If one of us has a spreadsheet
open, the other can only open the same spreadsheet in 'Read Only'. Is there
a newer version of Excel which will allow two people to have open, and edit,
and same worksheet at the same time? If not, anyone know of another program
which will allow this?

 

[JulieD]

Hi Alfred

you can "share" a workbook in excel 2000 (which allows for more than one
person to open & edit it at once) ... have a look in Help you'll find
details on how to do it, but basically the steps are:

On the Tools menu, click Share Workbook, and then click the Editing tab.
1.. Click to select the Allow changes by more than one user at the same
time check box, and then click OK.
2.. When prompted, save the workbook.
3.. On the File menu, click Save As, and then save the shared workbook on
a network location where other users can gain access to it.
this is from
(http://support.microsoft.com/default.aspx?scid=kb;en-us;269860&Product=xlw2
K ((HOW TO: Use Shared Workbooks with Different Versions of Excel,
Including Excel 2000))

However, you need to be aware some features aren't available if you share
workbooks, check out the following article for details
http://support.microsoft.com/default.aspx?scid=kb;en-us;130560&Product=xlw2K

Regards
JulieD

 

[Gilles Desjardins]

Yes, Access will allow up to 10 persons to work on the same database as long
as they are not working on the same record.

HTH

Gilles

 

[Earl Kiosterud]

Alfred,

JulieD has given you a good answer about using workbook sharing, with its
caveats. One thing that is sometimes not brought out about sharing is that
the multiple users are working with separate copies of the workbook as it
was when they opened it. They don't see each other's changes. It's not a
real-time data base.