I've never used it but per Help, for "Compare and Merge" to work the
workbooks must be 1) set up as Shared workbooks and 2) all stored in the
same folder with different names.
Do your files meet this criteria?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.