For this, you need to give each copy you receive a different name and save them in the same folder. Once you get the file back, you can then use the compare and merge command. You can use whatever means of distributing the file, whether online or offline. Related: How to Protect a Worksheet in Excel (The Beginner’s Guide) Step 6: Send the File to OthersĪll that’s left now is to send the same Excel workbook file to others. To make sure the change history will not be removed by any users, activate the “Protect Shared Workbook” command.Ĭheck the “Sharing with track changes” options and click the “OK” button. Leave the default options and click “OK” to proceed. You can also edit the advanced options including the change history and choosing between conflict changes. However, this allows you to track who has the workbook open and allows workbook merging later on. This command doesn’t literally share the workbook with others. Go to the tab where you added the command (in my case, it’s on the newly created “Extra” tab)Įnable the track changes while editing mode and enable the “When: All” and “Who: Everyone” options as shown below.Ĭlick “OK” to save the changes.Since you will be passing the shared Excel file around, it’s important to know what changes have been made. Disable (uncheck) the “Remove personal information…” setting.In the Trust Center window, do the following: Step 2: Change Property Optionsīefore you can track the changes, you must change a setting first on the property options. If you encounter an error, that means you need to either select an existing tab on the toolbar first or create a new tab and group.īelow, you will see that the commands are under the Extra tab > Traditional Sharing.ĭon’t forget to hit the “OK” button once you’re done. In the new window, select “Commands Not in the Ribbon” and add the following commands: Right-click on the ribbon first and select “Customize the Ribbon” from the options. To use them, you need to bring them out first on the toolbar. Most of what you need to traditionally share the others are part of the legacy commands. Don’t worry about that as we will also cover it in one of the steps below. You might wonder how the changes made will be compiled. On the other hand, you can also try the traditional method of sharing, which is equivalent to passing a copy of the file around. With Excel live collaboration, coauthoring is definitely the best. Method 2: Sharing Excel File With Tracked Changes But if you’re working on it at the same time, you will be able to see what the other users are changing in the document. The downside to this is that you will not be able to track any changes on any coauthored documents. Through this method, other persons with whom you shared the file will be able to make changes to the Excel document. If you have uploaded the file via OneDrive without opening the Excel file on your desktop, you can share it with others by clicking the “Share” button beside the filename and copying the link from there. You can also copy the link and share the link directly through email with other OneDrive users. If you used the “Share” button on Excel to upload the file, you will see a new window where you can edit the share link properties and directly share the file with other members through name, group, or email. Related: How to Share Files on OneDrive With External Users (Guide) Step 2: Share the File with Others The alternative way of doing this is to visit your OneDrive folder and either drag the file directly to the folder or use the “Upload” button. The simplest way is to click the “Share” button on Microsoft Excel and select which OneDrive to upload the file to. Here are the steps to do that: Step 1: Upload the Excel File to OneDrive It’s the most intuitive way of sharing files for Microsoft product users that’s almost on par with Google. Microsoft recommends coauthoring when it comes to sharing Excel files with multiple users. Method 1: Coauthoring Excel File With Other Users Method 2: Sharing Excel File With Tracked Changes.Step 1: Upload the Excel File to OneDrive.Method 1: Coauthoring Excel File With Other Users.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |