Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is anybody aware of why "Compare and Merge Worksheets" is grayed out in my Microsoft Excel Tools menu bar? I have open a Microsoft Excel Worksheet with only Sheet1 filled in and the rest empty. I want to compare it with a previous version of the same document.

    Regards,

    JMT

  2. #2
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by jmt356 View Post
    Is anybody aware of why "Compare and Merge Worksheets" is grayed out in my Microsoft Excel Tools menu bar? I have open a Microsoft Excel Worksheet with only Sheet1 filled in and the rest empty. I want to compare it with a previous version of the same document.

    Regards,

    JMT
    "Compare and Merge Worksheets" works when you share a workbook, allowing other users to modify the contents.

    [attachment=87374:untitled.JPG]
    Attached Images Attached Images
    Regards
    Prasad

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Please note that sharing a workbook is likely to corrupt it sooner or later...

  4. #4
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    But isn't it like Microsoft Word where I can make changes to a document, save it as another name, and then compare it with the previous version to see all of the changes I made? How does Excel know whether the changes were made by me or by another user that I shared it with and why would Excel care?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Excel is very different from Word in many ways. It has been/is being developed by a completely different team.

  6. #6
    5 Star Lounger
    Join Date
    Aug 2006
    Posts
    784
    Thanks
    0
    Thanked 0 Times in 0 Posts
    So if I email the original document and my revised document to a friend, have him email me back the revised document under a different name, and then ask Excel compare the revisions with the original, can I trick Excel into thinking I shared the document with a friend and I want to view his changes?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    No, not really. You'd have to turn on track changes before sending the workbook, but this automatically turns on sharing the workbook. As mentioned, sharing a workbook is dangerous, it can easily cause the workbook to become corrupted.
    The alternative is to create a sheet with formulas that compare corresponding cells in the original worksheet and the edited one.

  8. #8
    Lounger
    Join Date
    Dec 2009
    Location
    Bloomington, MN, USA
    Posts
    26
    Thanks
    1
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by Slinky View Post
    ...The alternative is to create a sheet with formulas that compare corresponding cells in the original worksheet and the edited one.
    What I'm hearing is that Excel doesn't have the capability of comparing two (unshared) worksheets. Is that correct?

    Could you elaborate on your suggestion? I think I could do something like this and just tell 'Same' or 'Different' for each corresponding cell. Is there a way I could display the old and new contents of the cell? Is there a way I could detect added or deleted rows?

    Thanks for your help.

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    There is no built-in way to do it. You can do it with code. On Chip Pearson's page http://www.cpearson.com/EXCEL/whatsnew.aspx called Compare.xla which may help you to compare...

    Steve

  10. #10
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Quote Originally Posted by sdckapr View Post
    You can do it with code.
    Or formulas - I always assumed this ability is why a comparison function was not a priority in Excel.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •