share and merge workbooks
 

I cannot get this to work, and I cant figure out what Im doing wrong. Im
saving the workbook as a shared workbook. Then Im saving test copies to
merge. When I go to compare and merge I get a message saying the workbooks
cant be merged. €œcannot be merged into the current workbook. Workbooks to be
merged must be copies made from the same shared workbook (is there a special
save option that Im not doing ?) and must all maintain the change history
for a sufficient amount of time (currently I set it at 30 days).
--
excel student