I don't find that with my Excel 2003 unless I am running two separate instances
of Excel and copying from one to the other.

If not your case, I don't have any more ideas.

How about copy and paste then Paste SpecialColumn Widths

Two steps but will get your columns straightened out.


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 16:00:02 -0800, Beto wrote:

If I highligh this worksheet and copy/paste into a blank sheet the columns
looses their actual widths.


"Sean Timmons" wrote:

Of course, you can avoid all of this by highlighting this worksheet and doing
a copy paste.

"Beto" wrote:

nothing happen at all.


"Gord Dibben" wrote:

With no workbook protection enabled under ToolsProtectionProtect Workbook my
guess would be the workbook is shared.

You should get a message to that effect when you attempt to copy the sheet.

Do you get no message?

Do you get any message?

Does nothing happen at all?


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 13:12:01 -0800, Beto wrote:

excel version 2003
neither the workbook or the sheet are protected
Does any one knows what could be the problem I am having?

Please help,
Beto

ps this problem is only on one of my files.