In this tutorial, you will find full details on how to share Excel workbook with other people by saving it to a local network or OneDrive, how to control user access to a shared Excel file and resolve conflicting changes.
Microsoft Office 2016 (codenamed Office 16) is a version of the Microsoft Office productivity suite, succeeding both Office 2013 and Office for Mac 2011, and preceding Office 2019 for both platforms. It was released on macOS on July 9, 2015 and on Microsoft Windows on September 22, 2015 for Office 365 subscribers. There's lots to cover, so if you're ready, let's get started with Office 2016 New Features. Practice while you learn with exercise files Download the files the instructor uses to teach the course. The next chapter of Office on Windows. By the Office 365 team. We are hard at work on the next release of the Office desktop suite that will be called Office 2016. (Unexpected, I know!). Microsoft named a 2018 Gartner Peer Insights Customers’ Choice for Content Collaboration Platforms (CCP) Read more. Keep up on all the. Microsoft Word Chapter 4: Practice Test. Four answers are incorrect and you will receive a 92! Microsoft Office 2010 includes _____ graphics, which are visual representations of information. Which indicates where text can be typed. Placeholder text.
Word allows you to restart page numbering on any page of your document. You can do this by inserting a section break and selecting the number you want to restart the numbering with. In our example, we'll restart the page numbering for our document's Works Cited section.
These days more and more people are using Microsoft Excel for team work. In the past, when you needed to share an Excel workbook with someone, you could send it as an email attachment or save your Excel data to PDF for printing. While fast and convenient, the former method created multiple versions of the same document, and the latter produced a secure though non-editable copy.
The recent versions of Excel 2010, 2013 and 2016 make it easy to share and collaborate on workbooks. By sharing an Excel file, you are giving other users access to the same document and allow them to make edits simultaneously, which saves you the trouble of keeping track of multiple versions.
How to share an Excel file
This section shows how to share an Excel workbook for multiple users by saving it to a local network location where other people can access it and make edits. You can keep track of those changes and accept or reject them.
With the workbook open, perform the following steps to share it:
If done correctly, the word [Shared] will appear to the right of the workbook's name as shown in the screenshot below:
Now, you and your colleagues can work on the same Excel file at the same time. You are free to accept or reject their changes, and after the desired changes have been incorporated, you can stop sharing the workbook. Further on in this tutorial, you will find the details on how to do all this.
Note. If Microsoft Excel refuses to share a certain workbook, most likely it's because of one of the following reasons:
How to share Excel workbook and protect change tracking
If you'd like not only to share an Excel file, but also to ensure that no one turns off the change history or removes the workbook from shared use, proceed in this way:
Clicking OK in the above dialog box will change the Protect and Share Workbook button on the ribbon to Unprotect Shared Workbook, and clicking this button will both remove the protection from the shared workbook and stop sharing it.
Note. If the workbook is already shared, and you want to protect sharing with a password, you must unshare the workbook first.
Text Chapter 17 –collaboration –my Office 2016 For Mac Free DownloadProtect worksheet vs. protect shared workbook
The Protect and Share Workbook option only prevents turning off change tracking in a shared workbook, but does not prevent other users from editing or deleting the workbook's contents.
If you want to prevent people from changing important information in your Excel document, you will need to lock some areas before sharing it ('before' is an important word here since the worksheet protection cannot be applied to an Excel shared workbook). For the detailed step-by-step instructions, please see:
Excel shared workbook limitations
When deciding to share your Excel file, please be aware that it may cause some troubles to your users because not all features are fully supported in shared workbooks. Here are some of the limitations:
In fact, you will be able to use the existing features, but you won't be able to add or change them. So, if you'd like to benefit from any of the above options, be sure to apply them before sharing your Excel file. The complete list of features unsupported in shared workbooks can be found on Microsoft's web-site.
How to edit an Excel shared workbook
After you open a shared workbook, you can enter new or change existing data in a regular way.
You can also identify your work in a shared workbook:
Now, you can input and edit data as usual, keeping in mind the following limitations of shared workbooks.
How to resolve conflicting changes in a shared Excel file
When two or more users are editing the same workbook simultaneously, some edits can affect the same cell(s). In such situations, Excel keeps the changes of the user who saves the workbook first. When another user tries to save the workbook, Excel displays the Resolve Conflicts dialog box with the details about each conflicting change:
To resolve conflicting changes, do one of the following:
Text Chapter 17 –collaboration –my Office 2016 For Mac Download
Tip. To save a copy of the shared workbook with all your changes, click the Cancel button in the Resolve Conflicts dialog box, and then save the workbook under a different name (File > Save As). You will be able to merge your changes at a later point.
How to force recent changes to override previous changes automatically
To have the most recent changes automatically override any previous changes (made by you or by other users), without displaying the Resolve Conflicts dialog box, do the following:
To view all the changes that have been made to the shared workbook, use the Track Changes feature on the Review tab, in the Changes group. It will show you when a particular change was made, who made it, and what data was changed. For more information, please see:
How to merge different copies of a shared workbook
In some situations, it can be more convenient to save several copies of a shared workbook, and then merge changes made by different users. Here's how:
Done! The changes by different users are merged into a single workbook. Now you can highlight the changes, so you can view all the edits at a glance.
How to remove users from a shared Excel workbook
Sharing an Excel file for multiple users can result in many conflicting changes. To avoid this, you may want to disconnect certain people from the shared workbook.
To remove a user from a shared workbook, do the following:
Note. This action disconnects users only for the current session, but does not prevent them from reopening and editing the shared Excel file again.
If the selected user is currently editing the shared workbook, Microsoft Excel will warn you that any unsaved changes of that user will be lost. You click OK to continue or Cancel to abort the operation and allow the user to save their work.
If it is you that have been disconnected, you can preserve your work by saving the shared workbook with a different name, then reopen the original shared workbook and merge your changes from the copy you've saved.
If you want to delete personal views of the removed user, switch to the View tab > Workbook Views group, and click Custom Views. In the CustomViews dialog box, select the views you want to remove, and click Delete.
How to unshare an Excel file
When the teamwork has been completed, you can stop sharing the workbook in this way: Group pictures and text boxes in ppt for mac.
Open the Share Workbook dialog box (Review tab > Changes group). On the Editing tab, clear the Allow changes by more than one user at the same time… check box, and click OK.
Excel will displays an alert that you are about to remove the file from shared use and erase the change History. If that's what you want, click Yes, otherwise No.
Notes:
How to share Excel workbook using OneDrive
Another way to share an Excel workbook is to save it to OneDrive, invite your colleagues to work on it, and see each other's changes instantaneously. Microsoft calls it co-authoring.
Text Chapter 17 –collaboration –my Office 2016 For MacSave and share a workbook
In Excel 2013 and Excel 2010, to save a workbook to OneDrive, perform these steps:
In Excel 2016, you can simply click the Share button in the upper-right corner, save the workbook to a cloud location (OneDrive, OneDrive for Business, or SharePoint Online library), type email addresses in the Invite people box, separating each with a semicolon, and then click the Share button on the pane (please see the screenshot below).
Clicking the Share button will send an email message to each person, a copy will be sent to you too, just in case. If you'd rather send the link yourself, click Get a sharing link at the bottom of the pane instead.
Co-author with other people
Text effect download for mac. When your colleagues receive an invitation, they simply click the link to open the workbook in Excel Online, and then click Edit Workbook > Edit in Browser to edit the file.
Excel 2016 for Office 365 subscribers (as well as users of Excel Mobile, Excel for iOS and Excel for Android) can co-author in their Excel desktop application by clicking Edit Workbook > Edit in Excel.
Tip. If you are using Excel 2016, you can also click File > Open, and then select Shared with Me.
Now, as soon as other people start editing the workbook, their names will appear in the upper-right corner (sometimes pictures, initials, or even 'G' that stands for guest). You can see other users' selections in different colors, your own selection is traditionally green:
Note. You may not see other people's selections if you are using a version other than Excel 2016 for Office 365 or Excel Online. However, all their edits to a shared workbook will appear in real time.
If multiple users are co-authoring, and you lose track of who is editing a specific cell, click on that cell, and the person's name will be revealed.
Best html text editor for mac.
To jump to the cell being edited by someone, click their name or picture, and then click the green box with the cell address.
This is how you can share an Excel file with other users. I thank you for reading and hope to see you on our blog next week!
You may also be interested in:
I am trying to combine eight files, each of which has its own TOC and footer. My objective is to create a single doc with one TOC at the front, and (eventually) to number the chapters n-n. The files contain mix of text, graphics, and lists (tables and columns).
I created a new doc with a title page. Then I used Insert Object > Text from File to bring the files into that new doc. (I tried it two ways: selecting multiple files from the list, and selecting and inserting one file at a time.) They came in, and I generated a TOC at the front. (After some trial and error, I discovered that I needed to delete the chapter TOCs before generating the new cumulative TOC.)
The new TOC got generated where I wanted it to go. Fine and dandy. The problem came with the page numbering in the TOC.
Word seems to have inserted some new Section Breaks (Next Page) in various pages, usually after a list or before a graphic. These breaks seem to throw off the page numbering. (These breaks are not in the original files; I've checked.) So, the new TOC might go from page 56 to page 0 and on from there. If I delete the Section Break at one location, it seems to jump backward in the combined doc, and the page numbering discrepancy goes with the break. So then I get page 17 followed by page 0 in the TOC. The footer page numbers match those in the TOC. The breaks are mostly within the chapter text, not between chapters (that is, not at the end of one file and the beginning of the next one).
My questions are:
Has anyone run into this kind of problem? If so, how did you solve it? I'm at my wits' end!
Thanks,
Nona
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |