[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Excel 2010

Posted on 2011-10-26
Medium Priority
Last Modified: 2012-08-13
Excel 2010, can more then 1 person open and edit a spreadsheet. the spreadsheets are on a shared network drive 2008 domain. please provide an article if possible///
Question by:Hubman

Author Comment

ID: 37032674
more then 1 person edit at the same time

Expert Comment

ID: 37032709
Yes, is the immediate answer by using Tools -> share workbook

It is reasonable easy to follow but, I would suggest having your format and layout well structured before you do this, otherwise great care must be taken by the individuals doing it as cell contents can be deleted, for example, but cells and/or rows/columns can not be deleted.

Hope this helps

Author Comment

ID: 37032732
where is tools in excel 2010
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.


Accepted Solution

andymacf earned 2000 total points
ID: 37032765
Apologies for that, if you click the 'Review' tab
LVL 81

Expert Comment

ID: 37032965
It should be noted that more than one person editing a workbook at the same time using the Share Workbook feature is notorious for file corruption problems. This problem is well-known in the expert community, and you'll get similar advice on any help forum: save frequently, and be prepared to restore the file from a tape backup.

The better solution is to switch to an application (like Access) that has robust multi-user capabilities. I realize that management may not want to hear this message, but the file corruption problem is real.

Expert Comment

ID: 37033026
Yes,In MS EXcel 2010 , it is allowed to edit worksheet, to multiple people to work in work book at the same time.But the workbook should be saved to a network location where multiple people can open it.
Note: Workbooks containing tables cannot be shared.
On the  REVIEW tab >Share workbook.

Hope this helps
--- Thanks

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

872 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