Shared Workbook

Excel Guy · #7 01-12-2012, 11:33 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining 2 workbooks into 1 workbook with TWO sheets	dguenther	Excel	1	10-06-2011 03:25 AM
Shared Excel workbook	eguru2	Excel	0	07-12-2011 12:02 AM
macro to transfer data from one workbook to another workbook	virsojour	Excel Programming	5	02-01-2011 08:58 PM
Select a range in one one workbook while working in other workbook	Slow&Steady	Excel	1	02-21-2010 03:34 AM
Share Workbook cannot merge	Ichigo	Excel	3	01-19-2010 03:05 AM