Solved

Multi-User Excel?

Posted on 2013-06-05
8
531 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
...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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 35

Assisted Solution

by:[ fanpages ]
[ fanpages ] earned 325 total points
Comment Utility
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
Comment Utility
http://docs.google.com/

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

Author Closing Comment

by:Patrick O'Dea
Comment Utility
THANKS!!
0
 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
You're welcome.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now