Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge copies of a shared workbook
I have a shared workbook and a copy I made to let another user edit. Usually,
the only change between the two is addition of data to a blank cell, but occasionally both workbooks might have data in a particular cell. When I run "compare and merge workbooks" it always replaces the data in my workbook (the original) with the data from the copy workbook. Is there any way to conveniently review these conflicts and let me decide which to accept? I played with "track changes" but ended up with a huge history sheet that was way too combersome to deal with (and I didn't really understand anyway). Also when setting up the "share workbook" originally, I selected the "ask me which changes win" options under <conflicting changes between users, thinking that would do the trick, but I still have the problem. I am hoping there is a straightforward way to deal with these few exceptions and that some kind soul can offer advice. Thanks! -- A Ford |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge w/ Shared Workbook in Word and Excel 2003 | Excel Discussion (Misc queries) | |||
update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
Excel shared workbook copies rows by itself | Excel Worksheet Functions | |||
Two copies of same workbook open... | Setting up and Configuration of Excel | |||
How to merge changes on a non-shared workbook | Excel Discussion (Misc queries) |