Compare and Merge is only available after sending out a shared file with
track changes switched on that Excel tracks and knows what is in both files

It places markers in both files and when the second file is returned, it
knows that they are linked and the function becomes active so you can then
merge the changes

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------

"Paul Wilson" <Paul wrote in message
...
I want to Compare two Excel Spreadsheets to highlight the changes that
have
been made between one and the other.

Unfortunately the "Compare and Merge Workbooks" function in the Tools menu
is greyed-out. It's not an Add-In, and I've tried installing the
functionality from the CD, but can't find anything.

any ideas?

thanks

Paul Wilson