I want to transfer a worksheet from one workbook ("A") to another ("B").
Workbook A is used in a third-party application.
I have in Excel no problem with workbook A or B.
However after I did the copy operation, workbook A gives an "OLE" error in the thirdparty application.
Then I tried to copy one line from B to A, same problem.
Even when I copy an empty cell from B to A, same problem.
It seems that something in B is corrupt, and the sligthest thing copied out of this workbook to workbook A brings this corruption to workbook A.
I tried to save the B-file in older format, and as xlb, but this doesn't help.
I think the problem is caused someway by compatibility problem: workbook B was made in Windows8 (Office15, Excel2013), workbook A in Office14 (Excel 2010).
But, I repeat, there is no problem opening workbook B in Office15 independent from the thirdparty application, neither in Office14.
I find no issues in the references.
Anyone an idea how I could copy the (huge) sheet from B to A, without copying the invisible corruption that seems to be in the workbooK?
Thanks!
VerlindenG
Bookmarks