Solved

Multi-User Excel?

Posted on 2013-06-05
8
573 Views
Last Modified: 2013-06-07
(I have googled this but thought I would ask the experts too)

Is it still true that only one user can work on one workbook at any one time?

If there are now multi-user facilities ... does that mean two users can use on WORKSHEET ?  Or can two users use one WORKBOOK?

What are the limitations of multiuser Excel (if, indeed it exists).?
0
Comment
Question by:Patrick O'Dea
8 Comments
 
LVL 17

Assisted Solution

by:Kent Dyer
Kent Dyer earned 75 total points
ID: 39223691
First question is why?  Sure, you could theoretically do this, but you are having to "band-aid" a solution..  Let me explain..  I am reminded of the Access database that was shared between several people when I worked at a previous company.  We had to use WRKGADM (part of Access) to manage permissions..  And sure you can link an Excel file to an Access Database too.  However, Access is not that good either as we had to constantly repair and shrink the Access database..  I know you are probably working with a small company that may not have much if any IT budget.  You should take some time and get your Excel file imported at least in to a SQL Engine (which is free, BTW)..  However, it is limited too - no searches, etc.  But, is lightyears better than Acess or Excel.  The, you could create a couple of ASP files to do the updates, deletes, etc.

Another way that you do this is to use SharePoint - where you can have users check in and check out the Excel file.

HTH,

Kent
0
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 325 total points
ID: 39223767
Hi,

Is it still true that only one user can work on one workbook at any one time?

No.

If there are now multi-user facilities ... does that mean two users can use on WORKSHEET ?  Or can two users use one WORKBOOK?

Multiple users can use one worksheet, or many worksheets, in one workbook concurrently.

This is not a new feature.

What are the limitations of multiuser Excel (if, indeed it exists).?

Historically, "Shared Workbooks" have not been very stable/robust, & the data contents were prone to "corrupt" resulting in data loss, or workbooks would remain "locked" when all users had closed them (meaning filing system operations [such as copy, move, & delete] could not be performed).

You will find many "Experts" offering advice/recommendations not to use "Shared Workbooks" because of the stability issues.

BFN,

fp.
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 100 total points
ID: 39223797
Echoing fp's comments...

Count me in the "stay away from shared workbooks" chorus.  They are just too unstable to be trusted for anything important.  It is only a slight exaggeration to say that there are only two kinds of shared workbooks: those that have been corrupted, and those that soon will be.

Seriously, the only use I can endorse for shared workbooks is to enable the "track changes" feature, and even then I would only allow one user in the file at a time.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39223808
...It is only a slight exaggeration to say that there are only two kinds of shared workbooks: those that have been corrupted, and those that soon will be.

:)
0
 
LVL 35

Assisted Solution

by:[ fanpages ]
[ fanpages ] earned 325 total points
ID: 39223859
Comments I made in January 2006:

[ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21693234.html#a15677466 ]
---
I agree with Kevin in that shared workbooks are too prone to error & should be avoided where possible.

However... "I tried using the Shared Workbook and worksheet functions, however, we keep running into the issue of her or my changes not be there the next time we access the worksheet"...

If another user makes a change in a shared workbook & saves their open copy, the changes will not be reflected in another shared users workbook until they save their open copy as well.

That is, a shared workbook allows multiple (concurrent) users on a network to view and make changes at the same time.
Each user who saves the workbook sees the changes made by other users.

Please ensure that before you wish to review any changes made by another (concurrent) user of the same workbook, that you save your open copy also.
---
0
 

Expert Comment

by:psmitty
ID: 39223980
http://docs.google.com/

You can use google docs and collaborate in real time.
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39227030
THANKS!!
0
 
LVL 35

Expert Comment

by:[ fanpages ]
ID: 39228298
You're welcome.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This collection of functions covers all the normal rounding methods of just about any numeric value.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question