Then click File > Save to save the workbook in its current location, then click File > Save As to save it to a public folder. Note: If you want to make an exist workbook shared, just open the workbook you want to share, click Review > Share Workbook, In the pop-up S hare Workbook dialog, click Editing tab and check the box on which beside Allow changes by more than one user at the same time. (Tip: You may sure that the public folder can be edited by all the staff.) Then click Save to save the workbook. Then click File > Save As to open the Save As dialog, and select a public folder to save it. In the pop-up Share Workbook dialog, click Editing tab and check the box on which beside Allow changes by more than one user at the same time. Type the address of your SharePoint site in the Location box and click Create. Click Review > Share Workbook to open the Share Workbook dialog. Open the workbook in Excel and select Tools Share Workspace. Provided there are no other users accessing the workbook, you should go ahead and click on Yes. When you turn off sharing and click on the OK button, Excel displays a warning that what you are doing may have consequences for other users. (Click Office button > New to create a new workbook in Office 2007.)Ģ. Excel displays the Share Workbook dialog box. In Microsoft Office 2010/2013, click File > New and select the workbook type you need to create a new workbook. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |