Microsoft Excel, SQL & Internet Tips : How to Merge Workbooks in Excel 2003

Microsoft Excel, SQL & Internet Tips : How to Merge Workbooks in Excel 2003


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.

Leave a Reply

Your email address will not be published. Required fields are marked *