Spreadsheets are a staple of an office. They are used to organize data and make reports. Whether you use an Internet-based spreadsheet program or the standard Microsoft Excel, you will need to share spreadsheet reports to your team or managers. Luckily, most spreadsheet programs have a built in feature to help you create a spreadsheet for use by many people, as long as you are using a shared server, or you have an Internet connection. This article will tell you how to make a shared spreadsheet in Microsoft Excel.
Open your excel spreadsheet or create a new document by going to the File Menu in the top horizontal toolbar and selecting “New.”
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.
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.
Click the Editing tab when the dialogue box pops up.
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.
Click “OK” to save that change.
Save the workbook in its current location by clicking the File Menu and selecting “Save.”
Go back to the File Menu and select “Save As.” 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.