I am unable to copy a worksheet
 

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.

I am unable to copy a worksheet
 

Exactly how are you trying to make a copy of the worksheet? Copy/paste?
Dragging the worksheet with Ctrl? Right clicking the worksheet tab and
selecting Move or Copy? And what message do you get when you try?

Regards,
Tyro

"Beto" wrote in message
...
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.

I am unable to copy a worksheet
 

Thank you Tyro
Right clicking the worksheet tab and selecting Copy
No message is display.

"Tyro" wrote:

Exactly how are you trying to make a copy of the worksheet? Copy/paste?
Dragging the worksheet with Ctrl? Right clicking the worksheet tab and
selecting Move or Copy? And what message do you get when you try?

Regards,
Tyro

"Beto" wrote in message
...
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.

I am unable to copy a worksheet
 

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.

I am unable to copy a worksheet
 

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.

I am unable to copy a worksheet
 

Right-click on sheet tab has no "copy sheet"

It has "Move or Copy" only and you must select the checkbox for "create a copy"

Perhaps you are just moving sheet1 from where it is to where it is.


Gord

On Sat, 8 Mar 2008 14:15:01 -0800, 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.

I am unable to copy a worksheet
 

You can copy within a shared workbook too. Perhaps some sort of crazy macro?

"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.

I am unable to copy a worksheet
 

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.

I am unable to copy a worksheet
 

It has "Move or Copy" only and you must select the checkbox for "create a copy"
This is correct and it is exactly what I have been doing. If I copy and
paste into a blank sheet the columns looses their actual widths.







"Gord Dibben" wrote:

Right-click on sheet tab has no "copy sheet"

Move or Copy" only and you must select the checkbox for "create a copy"

Perhaps you are just moving sheet1 from where it is to where it is.


Gord

On Sat, 8 Mar 2008 14:15:01 -0800, 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.

I am unable to copy a worksheet
 

What happens if you CTRL + a(twice in 2003) to select the entire sheet contents.

Now insert a new sheet, select A1 and Paste.


Gord

On Sat, 8 Mar 2008 15:43:01 -0800, Beto wrote:

It has "Move or Copy" only and you must select the checkbox for "create a copy"
This is correct and it is exactly what I have been doing. If I copy and
paste into a blank sheet the columns looses their actual widths.







"Gord Dibben" wrote:

Right-click on sheet tab has no "copy sheet"

Move or Copy" only and you must select the checkbox for "create a copy"

Perhaps you are just moving sheet1 from where it is to where it is.


Gord

On Sat, 8 Mar 2008 14:15:01 -0800, 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.

I am unable to copy a worksheet
 

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.

I am unable to copy a worksheet
 

Same. I think we beat this horse to death.

Thx,
Beto

ps I will open the file w/excel 2007 and see if that helps.


"Gord Dibben" wrote:

What happens if you CTRL + a(twice in 2003) to select the entire sheet contents.

Now insert a new sheet, select A1 and Paste.


Gord

On Sat, 8 Mar 2008 15:43:01 -0800, Beto wrote:

It has "Move or Copy" only and you must select the checkbox for "create a copy"
This is correct and it is exactly what I have been doing. If I copy and
paste into a blank sheet the columns looses their actual widths.







"Gord Dibben" wrote:

Right-click on sheet tab has no "copy sheet"

Move or Copy" only and you must select the checkbox for "create a copy"

Perhaps you are just moving sheet1 from where it is to where it is.


Gord

On Sat, 8 Mar 2008 14:15:01 -0800, 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.

I am unable to copy a worksheet
 

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.