<div>
Hi, brothertruffle880.<br />
<br />
Unless these Workbooks started life as copies of a shared workbook (plus some other constraints) then you may not use &quot;Merge and Compare&quot; on them.<br />
<br />
Are they shared?<br />
<br />
Thanks,<br />
Brian.
</div>


Hi, brothertruffle880.

Unless these Workbooks started life as copies of a shared workbook (plus some other constraints) then you may not use "Merge and Compare" on them.

Are they shared?

Thanks,
Brian.

<div>
They're all shared. &nbsp;Yes.
</div>


<div>
brothertruffle880,<br />
<br />
Thanks. The next steps...<br />
(1) Are they copies of the same, original, shared file?<br />
(2) Have they kept their change history since they were coped?<br />
<br />
Thanks,<br />
Brian.
</div>


brothertruffle880,

Thanks. The next steps...
(1) Are they copies of the same, original, shared file?
(2) Have they kept their change history since they were coped?

Thanks,
Brian.

<div>
They are copies of the same original file.<br />
I don't know if the changes history has been kept
</div>


They are copies of the same original file.
I don't know if the changes history has been kept

<div>
Brian:<br />
Thanks. &nbsp;It was the history. &nbsp;All fixed.
</div>


Brian:
Thanks.  It was the history.  All fixed.

<div>
Glad you're sorted, brothertruffle880.
</div>


<div>
<div class="content wysiwyg-content">
I have several workbooks that are identical except for a blank column which is populated by phone extensions. &nbsp;I am trying to merge these workbooks into my &nbsp;workbook and I get the following error message. &nbsp;How can I troubleshoot this?<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/08_w33/596628/err.png" target="_blank" title="err (11 KB)"><img alt="err" class="file-block lazyload" style="max-width: 779px;" data-src="https://filedb.experts-exchange.com/incoming/2012/08_w33/596628/err.png" /></a>
</div>
</div>


err.png

I have several workbooks that are identical except for a blank column which is populated by phone extensions.  I am trying to merge these workbooks into my  workbook and I get the following error message.  How can I troubleshoot this?


Excel 2010 - Merging workbooks error message

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.