I've googled this question, and now I have more: Is there a way to compare two different Excel spreadsheets/worksheets?

I've come up with software programs in my googling that do this. Is there any way to do this without an external program?

Here is my problem: I sent a spreadsheet to someone who made some changes, turns out I've been making changes also. I need to compare the two files (manually would take waaay too much time).

If there is no option other than another software program, what program do you suggest?

Thanks.

I have not used Excel for quite some time, so not sure if this will work.

What if you inserted an 'IF' command into A1 on a new worksheet, and copied it to all cells. Something like =IF(Sheet2!A1=Sheet3!A1,,"error") where Sheet2 and Sheet3 are your target files.

If the cells do NOT match exactly, it will show an 'error' in each cell.

Jar,

What sorts of changes have been being made? Are you just talking figures, or are you talking about formulae and/or VBA code?

Just figures and text. Don't think any of the simple formulae would be involved.

Forgot to mention, I have Microsoft Office 2007.

If you just need to do it once, then the simplest way might be just a trial version of some of the software that exists to do this. Try http://www.formulasoft.com/xlsc.html

Ozz is right, though. Especially if you are just using a single worksheet on each workbook, it should be pretty easy to just write that formula, and drag it over the length and breadth of the spreadsheet.

Thanks much. I'll give it a try and see what I can mess up!

With some luck, I might remember to copy every file, first!