I can think of two things.

1. The sheet is protected, which you say is not the case.

2. The workbook is Shared under ToolsShare Workbook.


Gord Dibben MS Excel MVP

On Wed, 9 Apr 2008 12:17:03 -0700, MRHRDWR <david.sartain@norandex .com wrote:

I too have this problem. I have a workbook i built over a year ago and
suddenly this week the merge button is greyed out. I have no protections on
my workbook, but suddenly it just stopped. I need to be able to merge and
unmerge as I have been doing for over a year now on my spreadsheets.
thank you