Quote:
Originally Posted by Richard Buttrey
Yes I know that. But unless I'm mistaken he was talking about completely detached copies of the same workbook and thinking that these could be merged with the standard Workbook merge functionality. e.g. books called Book1, Book2, rather than multiple copies of Book1 on a common server.
Am I mistaken and you can merge Book1 and Book2 in the way envisaged?
Regards
|
Yes, you can merge seperate workbooks (book1, book2) if:
1) the orginal was a shared workbook (call it book1)
2) And the other workbook (book2, book3, etc) derived from book1 (book1 saved as book2 and so on)
So basically he'll be able to open his copy book1 and merge/compare the other copies he got back (book2, book3, etc) using the merge/compare functionality.
The button isn't exposed by default, will need to add it to the QAT. Haven't heard from the OP on this, but from what I understand this is what he is trying to accomplish