How to Merge Workbooks in Excel 2003

Video Transcript

"Hi, my name's Dave Andrews. Today I'm going to show you how to merge Workbooks in Excel 2003. Let's open up Excel by clicking on the start button. Let's go to all programs. Let's find Microsoft Office. Let's launch Excel 2003. Now, what we're going to do is create a workbook that we can merge with other workbooks. This is in an environment where you're going to be collaborating with multiple people who are all editing the same Excel file and you want to merge them together. What I'm going to do, I'm going to type a little bit of text. And we'll save this workbook. I'm going to call it just Book One and say save. Now the first thing we have to do is share the workbook. So, go up to the tools menu and select share. Check this little check box up here that says this allows workbook merging and say okay. It's going to warn you that it's going to save the document. That's fine, so let's say okay. Now, let's act like we're editing the second workbook and type in some more text. Let's save this as Book Two. I'm going to close Book Two and open back up Book One. Now our second edit is gone because it's stored in Book Two. Let's merge these two together by clicking on tools. Compare and merge workbook. It's going to tell you it's going to save. That's fine. So then let's select Book Two. As you can see, the data that was in our second workbook has been loaded into the first workbook and any cells that have changed are showing up in red. My name is Dave Andrews and I've just showed you how to merge workbooks in Excel 2003."