Microsoft Excel is a part of Microsoft Office Suite. It is spreadsheet application software, written and distributed by Microsoft itself. It is developed for Microsoft Windows and Mac Operating System. This application of Microsoft office comes along with many features like calculator, pivot tables, graphing tools and a macro programming language known as VBA (Visual Basic for Applications). The current versions of Microsoft excel is Microsoft Office Excel 2010 for Windows and Microsoft Office Excel 2008 for Mac.
A workbook is a file in Microsoft Excel in which you can enter and store the data. A worksheet is also known as spreadsheet. A workbook contains a collection of cells in which you can keep and manipulate the data. A workbook can have multiple worksheets. It acts just like a book as the workbook contains the whole story while the worksheet contains the part of stories. Now, I will discuss how we can Merge Workbooks in Microsoft Excel.
In Microsoft Excel, you can evenly distribute the copies of spreadsheet. You should have the reviewers input provided, and then you can “merge” the copies review back into a single workbook. To perform this task, first of all you need to set up the basic workbook. The status of workbook should be “shared,” then you can merge the shared copies back into a single workbook. To merge the Workbook, you need the Excel Book and Microsoft Excel.
Now, I am going to discuss step-by-step procedure to merge the Workbook in Microsoft Excel.
Step 1: Open up the workbook for which you want to make distribution.
Step 2: Click on Share Workbook from the option provided in tools menu and then you have to click on the Editing tab.
Step 3: Select the option “Allow changes by more than one user at the same time” in editing option.
Step 4: Click on Advanced tab.
Step 5: You have to click on “Keep change history for” under the “Track changes”
Step 6: You have to make alterations with the Days box. Type an entry for days few longer than the reviewers’ entry of days. This is to make changes and comments in your shared workbook.
Step 7: Click OK.
Step 8: Save your current workbook.
Step 9: Generate the copies of the workbook for distribution.
For this go to file menu and click on Save As command. You have to provide a different name for each of the copy, such as “Budget – copy1” and “Budget – copy2.”
Now you have to merge the Shared Workbooks. For this you have to go through the following steps:
Step 1: Open the base copy of workbook.
Step 2: Open Tools menu and opt for Merge Workbooks.
Step 3: Save the shared workbook
Step 4: In the box that appears to you on the screen, select a copy.
Step 5: Now, Click OK.
Step 6: Finally, you have to repeat the steps until all shared workbooks get merged.