| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am unable to insert, move, copy a worksheet | Excel Discussion (Misc queries) | |||
| Unable to copy Conditional Formatting | Excel Discussion (Misc queries) | |||
| Unable to make copy of worksheet in excel. Please help. | Excel Discussion (Misc queries) | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| unable to copy ss# format in excel | Excel Discussion (Misc queries) | |||
Linear Mode
