Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-10-2012, 12:24 PM
Richard Buttrey Richard Buttrey is offline Shared Workbook Windows Vista Shared Workbook Office 2007
Novice
 
Join Date: Jan 2012
Posts: 3
Richard Buttrey is on a distinguished road
Default

Quote:
Originally Posted by Excel Guy View Post
There is a compare and merge function in excel where you can compare and merge two shared workbook, as long as one of the workbooks derived from the other.

So if you take your shared workbook and send a copy to the other user(s), once you get their copy back, you can compare and merge the copies with yours.

Note that this only works with shared workbooks.
Unless I'm horribly mistaken I don't think that's correct. I don't believe you can take two completely independent copies of the same workbook, give them to two users remote from each other and expect to be able to merge them when they are returned.

Workbook sharing implies sharing the same workbook on a network - see the MS article http://office.microsoft.com/en-us/ex...001013057.aspx

Of course it only works with shared workbooks as you said, that's the whole point. The operative word is 'shared' (implicitly on a server). Merging, in the sense of bringing together completely separate instances of the workbook does not apply.

Regards
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Shared Workbook 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
Shared Workbook macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM
Shared Workbook 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft