Sometimes we may need to see and analyze the data in two different workbooks. Microsoft Office has provided a simple and easiest way to compare the data in two different workbooks in Excel 2003.
To compare workbooks:
1) Open the workbooks you want to compare side by side.
2) On the Window menu, click Compare Side by Side with.
