We have a condition if two sessions of Excel 2007 are open - each with one
workbook open in each session, that copy and paste will be work for the first
four operations and will not work.

However, if both workbooks are open in the same session the copy and pasted
doesn't have this problem.

The file size of the workbook are not huge 1M on one and 3M on the other.
No macro's on either workbook - pivot tables are used extensively (deleted
the sheets that had the pivot tables - same problem still occurred.)

It didn't apprear that the clipboard was full.

Looked to see if this was a known error - could not find any documentation.
Any idea's