Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Sort" in Excel 2007 disabled--why? | Excel Discussion (Misc queries) | |||
Why is trace precedents disabled in Excel 2007 | Excel Discussion (Misc queries) | |||
2007: Property Sheet button disabled | Excel Discussion (Misc queries) | |||
Disabled item in Excel 2007 | New Users to Excel | |||
Merging workbooks in 2007 | Excel Discussion (Misc queries) |