Merging cells in shared file

[Erol]

When I share my excel sheet and when I copy a couple of rows with merged
cells what happens is that the rows are copied with data in it; however, the
merge is lost.

And when I try to merge the cells manually it doesn't give me the option (it
is greyed out).

Is there any way I can keep my merged cells while keeping the file shared? I
have MS 2000, is it related with my version?

Thanks in advance

 

[Jim Thomlinson]

Your question involves 2 of the most problematic features of XL. Merged Cells
cause a great deal of havoc an mayhem with macros. Sharing a workbook is
essentailly a form of protection that locks out a number of features of XL
with merging being one of them.

Try this. Instead of merging the cell tru just centering it across the
selection.
1. Unmerge the cell
2. Select the affected cells
3. Select Format -> Cells -> Allignment (tab) -> Horizontal -> Center Across
Selection

 

[Erol]

Thanks Jim,

I will definetly use the "center across selection" trick, I never knew that.
But my sheet contains a lot of merging both vertically and horizontally and I
spent lots of time making sure the sheet looks like the way I want. So I
guess I will not share the document.

But at least its good to know its not doable.

Thanks again