Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 791
Default Excel 2007 - Why is Cell Merging Disabled?

I received a workbook where the cell merge functions are disabled. This was
not done on purpose and the worksheet/workbook is NOT protected in any shape
or form. Orginally when the workbook was created it did allow merging.

All we know is the workbook was created in Office 2007 - down convertd to
Office 2003 and then opened in Office 2007. We do not believe this has
anything to do with the issue.

Does anybody know what causes the merge function (outside of protection) to
disable in 2007?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2007 - Why is Cell Merging Disabled?

Another thing to check...

Is the workbook shared?



Michael wrote:

I received a workbook where the cell merge functions are disabled. This was
not done on purpose and the worksheet/workbook is NOT protected in any shape
or form. Orginally when the workbook was created it did allow merging.

All we know is the workbook was created in Office 2007 - down convertd to
Office 2003 and then opened in Office 2007. We do not believe this has
anything to do with the issue.

Does anybody know what causes the merge function (outside of protection) to
disable in 2007?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 791
Default Excel 2007 - Why is Cell Merging Disabled?

Good thought - but alas it is not.

We have also noticed that depending on who opens the workbook, the merge
cell function may be completely disabled for all worksheets (even newly
created), or only disabled for some cells and some worksheets.


"Dave Peterson" wrote:

Another thing to check...

Is the workbook shared?



Michael wrote:

I received a workbook where the cell merge functions are disabled. This was
not done on purpose and the worksheet/workbook is NOT protected in any shape
or form. Orginally when the workbook was created it did allow merging.

All we know is the workbook was created in Office 2007 - down convertd to
Office 2003 and then opened in Office 2007. We do not believe this has
anything to do with the issue.

Does anybody know what causes the merge function (outside of protection) to
disable in 2007?


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 791
Default Excel 2007 - Why is Cell Merging Disabled?

We have also noticed that depending on who opens the workbook, the merge cell
function may be completely disabled for all worksheets (even newly created),
or only disabled for some cells and some worksheets.


"Michael" wrote:

I received a workbook where the cell merge functions are disabled. This was
not done on purpose and the worksheet/workbook is NOT protected in any shape
or form. Orginally when the workbook was created it did allow merging.

All we know is the workbook was created in Office 2007 - down convertd to
Office 2003 and then opened in Office 2007. We do not believe this has
anything to do with the issue.

Does anybody know what causes the merge function (outside of protection) to
disable in 2007?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel 2007 - Why is Cell Merging Disabled?

I don't have any other guesses.

Sorry.

Michael wrote:

We have also noticed that depending on who opens the workbook, the merge cell
function may be completely disabled for all worksheets (even newly created),
or only disabled for some cells and some worksheets.


"Michael" wrote:

I received a workbook where the cell merge functions are disabled. This was
not done on purpose and the worksheet/workbook is NOT protected in any shape
or form. Orginally when the workbook was created it did allow merging.

All we know is the workbook was created in Office 2007 - down convertd to
Office 2003 and then opened in Office 2007. We do not believe this has
anything to do with the issue.

Does anybody know what causes the merge function (outside of protection) to
disable in 2007?



--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Excel 2007 - Why is Cell Merging Disabled?

Like Dave, I have no guesses but IMO, consider yourself fortunate that you are
unable to use the "merge cells" feature.

Save yourself a lot of grief down the road.


Gord Dibben MS Excel MVP

On Thu, 24 Apr 2008 08:25:00 -0700, Michael
wrote:

Good thought - but alas it is not.

We have also noticed that depending on who opens the workbook, the merge
cell function may be completely disabled for all worksheets (even newly
created), or only disabled for some cells and some worksheets.


"Dave Peterson" wrote:

Another thing to check...

Is the workbook shared?



Michael wrote:

I received a workbook where the cell merge functions are disabled. This was
not done on purpose and the worksheet/workbook is NOT protected in any shape
or form. Orginally when the workbook was created it did allow merging.

All we know is the workbook was created in Office 2007 - down convertd to
Office 2003 and then opened in Office 2007. We do not believe this has
anything to do with the issue.

Does anybody know what causes the merge function (outside of protection) to
disable in 2007?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Sort" in Excel 2007 disabled--why? BillK62 Excel Discussion (Misc queries) 4 April 5th 23 01:10 PM
Why is trace precedents disabled in Excel 2007 Bill Excel Discussion (Misc queries) 2 March 20th 08 08:44 PM
2007: Property Sheet button disabled Richard H Excel Discussion (Misc queries) 5 February 26th 08 03:21 AM
Disabled item in Excel 2007 pcor New Users to Excel 3 November 1st 07 02:52 PM
Merging workbooks in 2007 scoz Excel Discussion (Misc queries) 0 October 10th 07 02:51 PM


All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"