Sharing Workbook – Simultaneous edit on excel files

shareworkbookDid you ever faced problem with consolidating excel sheets ? Usually we share large excel files work with colleagues. and consolidate after the their work. Some time we need to share one excel file to others and they want to edit it simultaneously. Most of the users share the file in network (File server / FTP). But if some one open the file, others can just open it as read only.

How can we edit an excel file simultaneously? You have an option to share work book in excel. This is especially useful in a typical office environment where files are shared over a network.  It is known as “Share Workbook” Following are the steps to enable it

1. Go to Tools menu
2. Click Share Workbook
3. Click the Editing tab
4. Select the Allow changes by more than one user at the same time check box,
5. Click OK.
6. Save file to a Network shared location.

shareworkbok2

Excel 2003

Excel 2007

Excel 2007

Before you start sharing your workbook, note that not all features will work in a shared workbook. If you want to add any of the items below you should do so before you start sharing your workbook, and you cannot change these features while the workbook is being shared:

Limitation of sharing workbook
You cannot change following features while the workbook is being share

Charts ,Conditional formats, Data tables, Data validation, Hyperlinks, Macros, Merged cells, Outlines, Pictures, Pivot table reports, Scenarios, Subtotals

About Albin Sebastian

I am a Technology Blogger, System Administrator by profession and webmaster by passion. Technology blogger, Active in Online and offline tech communities.

Check Also

MySql replication

Disaster recovery of Mysql using DRBD and Heartbeat

Disaster recovery (DR) is the process, policies and procedures that are related to preparing for …