I am unable to copy a worksheet

B

Beto

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

Tyro

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
 
B

Beto

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

Gord Dibben

With no workbook protection enabled under Tools>Protection>Protect 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
 
B

Beto

nothing happen at all.


Gord Dibben said:
With no workbook protection enabled under Tools>Protection>Protect 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
Click to expand...
 
G

Gord Dibben

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
 
S

Sean Timmons

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

Sean Timmons

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

Beto

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

Gord Dibben

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
 
B

Beto

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

Beto

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

Gord Dibben

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 Special>Column Widths

Two steps but will get your columns straightened out.


Gord Dibben MS Excel MVP
 
Top