How to Make a Shared Spreadsheet

Step-by-Step Guide

1. 1

   Step 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. 2

   Step 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. , Select "Shared Spreadsheet/Share Workbook" from the options in the drop down menu. ,, Click on that box to affirm you want that change. ,, , , 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.
3. 3

   Step 3: Click on the Tools Menu or in other version you can find the Review Tab.

4. 4

   Step 4: Click the Editing tab when the dialogue box pops up.

5. 5

   Step 5: Find the box that says "Allow changes by more than one user at the same time."

6. 6

   Step 6: Click "OK" to save that change.

7. 7

   Step 7: Save the workbook in its current location by clicking the File Menu and selecting "Save."

8. 8

   Step 8: Go back to the File Menu and select "Save As."

9. 9

   Step 9: Save the file in a shared folder on a shared network.

Detailed Guide

About the Author