Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Can't copy sheet in Excel


  • Please log in to reply

#1
tom1011

tom1011

    New Member

  • Member
  • Pip
  • 3 posts
In some spreadsheet files, I'm not able to create a duplicate of an excel worksheet. I do the normal "move or copy sheet" and "create a copy" in the edit function, but it won't let me copy that particular worksheet. Nothing happens.

This doesn't happen often, but has happened in a few worksheets. The worksheets are unprotected. Can anyone help me?
  • 0

Advertisements


#2
pip22

pip22

    Trusted Tech

  • Banned
  • PipPipPipPipPip
  • 2,663 posts
Can you go to 'Edit>Select All' on the sheet you want to copy, then open a new document and go to 'Edit>Paste' ?

Edited by pip22, 08 January 2007 - 08:08 AM.

  • 0

#3
tom1011

tom1011

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts

Can you go to 'Edit>Select All' on the sheet you want to copy, then open a new document and go to 'Edit>Paste' ?



Yes, that fixed it! Thanks.
  • 0

#4
Aeolian

Aeolian

    New Member

  • Member
  • Pip
  • 1 posts

Can you go to 'Edit>Select All' on the sheet you want to copy, then open a new document and go to 'Edit>Paste' ?



Yes, that fixed it! Thanks.


Well, that may solve the problem but doesnt answer the question why the normal sheet copy/paste function doesnt work. I have the same problem while running a script that should create a number of sheets authomatically.

I use a copy function made by XL Dennis. You see it below. It works beautifully. But at some point I get the same error as our friend. I have the suspition that the copy/paste cache get full and therefore is not able to contain more info so the sheet copy/paste doesnt work anymore.

No ideas around?


Sub Add_sheet(sheetname)

'© 2002 XL-Dennis

Dim stNameField As String
Dim oObjekt As Object
Dim wsBlad As Worksheet
Dim rnCell As Range
Dim i As Integer

Application.ScreenUpdating = False
i = Worksheets.Count
' ActiveSheet.Copy after:=Worksheets(2)
ActiveSheet.Copy after:=Worksheets(i)
i = i + 1
Set wsBlad = Worksheets(i)

'Ifall det inte finns formler
On Error Resume Next

For Each rnCell In wsBlad.Cells.SpecialCells(xlFormulas)
rnCell.Value = rnCell.Value
Next
Application.ScreenUpdating = True

stNameField = blad
' = CStr(wsBlad.Range("A1").Value)

With wsBlad
For Each oObjekt In .Shapes
oObjekt.Delete
Next
.Name = stNameField
'.Range("H1:H40").Clear
End With

End Sub
  • 0

#5
markinomaha

markinomaha

    New Member

  • Member
  • Pip
  • 1 posts
I used to get the same error message occassional with Windows XP. If you would close the worksheets, then reopen them it would then work. I don't want to copy and paste, I want to move the entire worksheet so you don't lose the existing page breaks. Now we have Windows 7 and the problem is worse. Is there a fix? The error message I'm getting (about rows and columns not matching in the source workbook) makes no sense because I'm trying to move the entire worksheet. I run financials from our accounting software, covert it into an Excel Sheet, then consolidate them into one workbook. There is no reason it shouldn't work, yet it doesn't. Is there a fix to this problem?
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP