Thread: [Solved] Shared Workbook
View Single Post
 
Old 01-12-2012, 11:33 AM
Excel Guy Excel Guy is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2012
Posts: 3
Excel Guy is on a distinguished road
Default

Quote:
Originally Posted by Richard Buttrey View Post
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

Last edited by Excel Guy; 01-12-2012 at 12:55 PM.
Reply With Quote