BW,
What if you disable the Office clipboard, forcing Excel to use the Windows
clipboard instead.
http://techsupt.winbatch.com/TS/T000001071F4.html

NickHK

"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