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.
MS Exel 2003
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhcBMZVMOwFZxaxT1JUlP2fW_kGf7btC3Yl1arhnnzswgxlwqjS0JfFmjAMrYM9XNQf-ymExEMgo8pjjrsQuHe8PBJPkTAOi3gNJenNxmY8KEpcnuyDycaRMxBngovhut5C-oNSpfUVZk7i/s320/workbok.jpg)
MS Exel 2007
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9t59weIkQ-dhTTEcTF9ro0ouUu3i6cUe8khB5HKMu7EeuY0L8UKBCefoZQon3btzRNZx5qgRMpOodYcO6Dqt-b3AI-g6W5PFEZQEvAtRQjEjY1K4Jv449en-G8o-0sstBLFk8xPxXsihW/s320/share2007.jpg)
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
No comments:
Post a Comment