Why is compare and merge greyed out in excel

Now I have to blow it up which is not a desirable method especially when I have made changes that I wanted to save. After I installed "Compare and Merge Workbooks" on the ribbon, however, it is greyed out. I want to Compare two Excel Spreadsheets to highlight the changes that have been made between one and the other.

This is the only thing that I think I have changed since protecting this morning and now I cannot unprotect the sheet. I've lost my menu bar in Excel. But after doing the steps above, the buttons are available on the Quick Access Toolbar instead.

Also i tried to load the "inquire" add-in under COM plugins but its not available. Is there any way to stop a macro from running when it gets hung up and my excel is "Not Responding"?

I tried searching before I posted this, but the suggestions given didn't seem to work for me. Sharing workbooks limitations - Merged Cells, I want to combine 2 workbook data bases and remove duplicates. This is weird. You'll need to choose a username for the site, which only take a couple of moments. When I try to make changes. I automating a task at work that will save some time.

I have cells in a column, some colored yellow, some not. Perhaps it is greyed out because you are in the chart and not on a worksheet cell. Once you have all the copies of the workbook back, save them in the same folder, and give each of them a unique name.

Now I need to expand the spreadsheet and use more columns. You are using an out of date browser. There is no button visible by default on toolbars but for sure Excel has got it, remember it can do anything provided you I have identifed times when I know the name is there on the sheet, but the find function says "Excel cannot find the data you are searching for".

Compare and Merge Workbooks button: You may encounter other articles that refer to these buttons being on the Review tab. I didn't write any macros and usings the right-click unhide method is proven futile. Sorry for the question. Want to reply to this thread or ask your own question? After you compare the data in two databases, Data Compare lists each database object that you compared and its status.

The download link for the file has been sent to the email you provided. Please remember, the Compare and Merge Workbooks feature allows merging only copies of the same shared workbook. I then have spent time on setting up a sheet to track changes just in case this has any bearing on the problem.

I want to merge two files but the 'Compare and Merge Workbooks' option is greyed out. I am trying to use, I would like to copy a small table from Word into one cell in an Excel.

I have protected a worksheet as it has several formulae on that I do not wat anyone else to mistakingly delete. Your e-mail address is not shared with anyone, ever. Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment.

All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. It would be great if you actually explained the steps to do this though. Off to google them now.

Thank you. Your portal helped me in lot of times where I need help in Excel. This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface. View the most recent newsletter. Toggle navigation. Author Bio. Many thanks, that is it, not doing the Share Workbook. Have a nice day. Post reply. Ask a Question Want to reply to this thread or ask your own question?

Ask a Question. Nov 10, Aug 15, Sharing workbooks limitations - Merged Cells. Feb 10, Cut, copy and paste greyed out. Apr 7, For example, to merge the cells A1 to D1 in the worksheet shown below, you just need to highlight the cells and click on the merge and center button.

If you want to unmerge the cell back to its original contents, you can simply click on the merged cell and click on the Merge and Center button again. Therefore, the Merge and Center button lets you do both. You can use it to merge a set of cells into one and you can use the same button to unmerge a merged cell into separate cells. If you look in the Alignment group, you will see the Merge and Center button, along with a dropdown arrow. You might want to use the Merge and Center button to either merge a set of cells or unmerge an already merged set of cells.

This is usually done to prevent users from changing, moving, or deleting information from the sheet , either accidentally or deliberately. An Excel user can also protect a worksheet to disallow users from making selected changes to a sheet, like inserting columns, formatting rows , etc. Putting a worksheet in protected mode usually allows the user to edit certain parts of the sheet, while most features are disabled to protect the data. For the same reason as above, it is possible that the whole workbook itself is in Protected mode.