Can not open clipboard

[West Man]

I have a spreadsheet that will not allow me to copy. I get the message "Can not open clipboard". This occured shortlt after the message that Excel does not have enough memory to complete the operation. I was dragging a formula down a few thousand cells.

I have tried exiting Excel and bringing up the spreadsheet again. I have also tried restarting the computer. All to no avail. The spreadsheet does not contain any macros.

Any ideas?

 

[VoG]

This might help you http://answers.microsoft.com/en-us/...lipboard/6a4aa646-72fd-4f1c-9127-c3e12bc9a4b3

 

[West Man]

Sorry, I should have specified Excel 2003

 

[West Man]

Upon trying to save I get the message that the picture is too large and will be truncated. No picture is in the sheet, at least not intentionally.

 

[VoG]

Try running this

Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long
Public Declare Function CloseClipboard Lib "user32" () As Long

Sub ClearClipboard()
    OpenClipboard (0&)
    EmptyClipboard
    CloseClipboard
End Sub

 

[West Man]

Thanks for the tips. After getting numerous different error messages, some quite unusual, I received a corrupted file message which is likely the real problem. Because I could reconstruct the spreadsheet fairly easily, I went that route rather than fighting it. Sometimes you have to know when to throw in the towel.

 

[eznsd]

Try running this

Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long
Public Declare Function CloseClipboard Lib "user32" () As Long

Sub ClearClipboard()
    OpenClipboard (0&)
    EmptyClipboard
    CloseClipboard
End Sub

I am having the same issue, but for different reasons. I am actually copying a large amount of data to the clipboard. I have also seen another variation of this code. I will let you know if it works for me.

 

[eznsd]

I am sorry to report that this did not work for me. Back to the drawing board.