Sharing Excel workbooks makes it easy to collaborate on data collection. But before you put your Excel files in the hands of other people, here are a few tips to get your worksheets ready for sharing. Allow Multiple Simultaneous Edits If you want multiple users to be able to edit a shared Excel sheet at the same time, do the following: Go to the Review tab and under Changes, click Share Workbook. In the dialog that opens up, make sure that Allow changes by more than one user at the same time is checked. Save your Excel file in a shared location where other users...
Read the full article: Before Sharing an Excel Spreadsheet, Make Sure You Do These Things First
from MakeUseOf http://ift.tt/2mpRHP2
via IFTTT
0 comments:
Post a Comment