[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel 2010 - Merging workbooks error message

Posted on 2012-08-15
7
Medium Priority
?
554 Views
Last Modified: 2012-08-26
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?
err
0
Comment
Question by:brothertruffle880
  • 4
  • 3
7 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 38300423
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.
0
 

Author Comment

by:brothertruffle880
ID: 38308710
They're all shared.  Yes.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38309128
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.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:brothertruffle880
ID: 38330467
They are copies of the same original file.
I don't know if the changes history has been kept
0
 
LVL 26

Accepted Solution

by:
redmondb earned 2000 total points
ID: 38330596
brothertruffle880,

If the change history is not being kept then you can't use Compare and Merge. To check...
 - On the Menu Bar, click on "Review".
 - Click on "Track Changes", then "Highlight Changes..."
 - On the "Highlight Changes" dialogue...
    - Untick "When", "Who" and "Where".
    - Tick "List changes on a new sheet."
    - Click "OK".
A new sheet should be created with a list of all of the changes, finishing with "The history ends with the changes saved on " followed by a date and time.

Do this for each of the files. Do any of them not have a history? Or does a history not go back sufficiently far?

Thanks,
Brian.
0
 

Author Comment

by:brothertruffle880
ID: 38333868
Brian:
Thanks.  It was the history.  All fixed.
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38333911
Glad you're sorted, brothertruffle880.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question