BW,

I have been running into this for years. The multiple instances might be
having an effect, but are not a pre-requisite. I've seen it on most versions
of Excel (but particularly 97 and 2000 - it seems to be better in XP),
regardless of the machine config. It's worse than you think too, because
sometimes error handling doesn't work and VBA just stops on the call causing
the clipboard error.

I've tried api calls, all the tricks this group can suggest, and have never
found a foolproof solution. Without any proof other than API calls having no
effect, I've come to believe that Excel uses a private clipboard that is
nothing to do with the windows clipboard, and that this sometimes fails when
under load copying pictures.

If you switch into the VBE you can typically step through the failing call
and resume your routine, but you won't want most of your users doing that.

No help, I'm afraid, but it's not just you.

Robin Hammond
www.enhanceddatasystems.com

"BW" wrote in message
...
Hello,

In an attempt to find a way of breaking a chart reference to worksheet
cells
in pre-Excel2003 by using the chart's Series formula/Series named array
and
avoiding the "Unable to set the XValues property of the Series class"
error
message when the formual/named array is very large and , i've tried
copying
the chart to the clipboard, then pasting back using the following code:

aWorksheet.ChartObjects.Item(1).Chart.CopyPicture Appearance:=xlScreen,
Size:=xlScreen, Format:=xlBitmap
aWorkbook.Sheets(1).Paste

The code above works but problem is if i have a user that opens many
INSTANCES of EXCEL.EXE each running an excel template that contain the
above
code and executes the above code simultaneously, i get the following
runtime
error message: "Cannot empty the Clipboard"

Based on the following KB article from MS:
http://msdn.microsoft.com/library/de...l=/library/en-
us/vbenlr98/html/vamsgclip2cantempty.asp

it appears one of the instances of excel is not releasing the clipboard.
Is
this true (??).

Other than trapping the error and trying to copy/paste a 2nd time in the
trapping subroutine, is there another solution to overcoming this "Cannot
empty the Clipboard" error message, or is there another reason for this
errror message?

Thanks