Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can't copy an Excel worksheet
I have been unable to make a copy of a worksheet within a file or by copying
it to a new workbook. When I try copying it to a new file, the new workbook appears temporarily and then disappears. Any suggestions would be appreciated. I am using Excel 2002. |
#2
|
|||
|
|||
How are you copying the worksheet?
ctrl-click and drag click on the worksheet tab and edit|move or copy worksheet. I've never had any trouble with this kind of thing. Maybe you could try doing the same stuff when you start excel in safe mode. close excel windows start button|run excel /safe File|open your workbook and copy that worksheet. ====== Another alternative while you're trying to figure out what's going on. Open your workbook file|Save as|a nice new name delete the worksheets you don't want. Save that new workbook with just that worksheet. Gaby wrote: I have been unable to make a copy of a worksheet within a file or by copying it to a new workbook. When I try copying it to a new file, the new workbook appears temporarily and then disappears. Any suggestions would be appreciated. I am using Excel 2002. -- Dave Peterson |
#3
|
|||
|
|||
Thanks, Dave. In the end I did your last option. It seems to be a corrupted
workbook. :( "Dave Peterson" wrote: How are you copying the worksheet? ctrl-click and drag click on the worksheet tab and edit|move or copy worksheet. I've never had any trouble with this kind of thing. Maybe you could try doing the same stuff when you start excel in safe mode. close excel windows start button|run excel /safe File|open your workbook and copy that worksheet. ====== Another alternative while you're trying to figure out what's going on. Open your workbook file|Save as|a nice new name delete the worksheets you don't want. Save that new workbook with just that worksheet. |
#4
|
|||
|
|||
If you think it's corrupted, then I think you may want to start rebuilding it.
If the workbook ever gets so bad you can't open it, well, you know the rest of the warning! === Ps. The one workbook that I had that was corrupted had the same kind of problem. I could move the sheet, but I couldn't copy it. I rebuilt that one sheet and haven't had any trouble since. (But man, oh, man, it was a pain rebuilding the worksheet.) Gaby wrote: Thanks, Dave. In the end I did your last option. It seems to be a corrupted workbook. :( "Dave Peterson" wrote: How are you copying the worksheet? ctrl-click and drag click on the worksheet tab and edit|move or copy worksheet. I've never had any trouble with this kind of thing. Maybe you could try doing the same stuff when you start excel in safe mode. close excel windows start button|run excel /safe File|open your workbook and copy that worksheet. ====== Another alternative while you're trying to figure out what's going on. Open your workbook file|Save as|a nice new name delete the worksheets you don't want. Save that new workbook with just that worksheet. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
exporting excel worksheet to word | Links and Linking in Excel | |||
excel 2002 - copying formulas to another worksheet | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |