Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-30-2011, 06:52 PM
SJT SJT is offline Shared Workbook Windows XP Shared Workbook Office 2007
Novice
Shared Workbook
 
Join Date: Nov 2011
Posts: 4
SJT is on a distinguished road
Default Shared Workbook


I would like to send a workbook to someone to enter some data as I continue working on other parts of the workbook. Without the use of a server, is there a way for me to send the shared workbook and then just compare and merge what I have with the data that he has input? I am using Excel 2007 with Windows XP. Thank you in advance for your assistance.
Reply With Quote
  #2  
Old 01-05-2012, 04:02 AM
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

Hi,

I don't believe so.
Workbook sharing, (which personally I don't rate very highly because it creates more problems than the limited benefits it offers), needs two or more users to be using the same instance of the workbook.

Your best solution would be to ensure that the data entered by the other user is readily identifiable and structured logically so that you can then use standard excel techniques to compare the two workbooks.

Regards
Reply With Quote
  #3  
Old 01-10-2012, 11:12 AM
Excel Guy Excel Guy is offline Shared Workbook Windows 7 64bit Shared Workbook Office 2010 64bit
Novice
 
Join Date: Jan 2012
Posts: 3
Excel Guy is on a distinguished road
Default

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.
Reply With Quote
  #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
  #5  
Old 01-11-2012, 11:10 AM
Excel Guy Excel Guy is offline Shared Workbook Windows 7 64bit Shared Workbook Office 2010 64bit
Novice
 
Join Date: Jan 2012
Posts: 3
Excel Guy is on a distinguished road
Default

Quote:
Originally Posted by SJT View Post
I would like to send a workbook to someone to enter some data as I continue working on other parts of the workbook. Without the use of a server, is there a way for me to send the shared workbook and then just compare and merge
If you look at what he is asking to do, the merge and compare function of shared workbooks would do what he is looking to do.

Merge copies of a shared workbook
http://office.microsoft.com/en-us/ex...010177169.aspx
Reply With Quote
  #6  
Old 01-11-2012, 12:06 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
If you look at what he is asking to do, the merge and compare function of shared workbooks would do what he is looking to do.

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
Reply With Quote
  #7  
Old 01-12-2012, 11:33 AM
Excel Guy Excel Guy is offline Shared Workbook Windows 7 64bit Shared Workbook 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
Reply

Thread Tools
Display Modes


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 01:53 PM.


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