How to Make a Shared Spreadsheet

Microsoft Excel Spreadsheet

1. 
   Open your excel spreadsheet or create a new document by going to the File Menu in the top horizontal toolbar and selecting "New."
2. 
   Make changes to your document. These should include macros, charts, merging cells. pictures, objects, hyperlinks, outlines, subtotals, data tables, Pivot Table reports, worksheet protection and conditional formats.
3. 
   Click on the Tools Menu or in other version you can find the Review Tab. Select "Shared Spreadsheet/Share Workbook" from the options in the drop down menu.
4. 
   Click the Editing tab when the dialogue box pops up.
5. 
   Find the box that says "Allow changes by more than one user at the same time." Click on that box to affirm you want that change.
6. 
   Click "OK" to save that change.
7. 
   Save the workbook in its current location by clicking the File Menu and selecting "Save."
8. 
   Go back to the File Menu and select "Save As."
9. 
   Save the file in a shared folder on a shared network. Make sure all the people that will use the document have permission to use that folder. If not, save it somewhere that everyone can access.