teomcam
asked on
Trying to "paste special" data between 2 excel instances, why does worksheet object appearing?
Hi,
I am trying to copy the data from an excel instance to the new one and paste special without any formulation. When I do that Paste Special option does not give me the options such as copy values only etc. Instead it forcing me to paste as bitmap.
How can I fix that?
I am trying to copy the data from an excel instance to the new one and paste special without any formulation. When I do that Paste Special option does not give me the options such as copy values only etc. Instead it forcing me to paste as bitmap.
How can I fix that?
ASKER
I don't have skype installed on this machine. In fact same issue on all machines even freshly installed ones. I believe there is a default setting to avoid that.
Hi,
Check your COM Add-Ins in Excel, can you list what you have there.
Check your COM Add-Ins in Excel, can you list what you have there.
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
Hi,
Also, please can you confirm that if you open the source workbook & the destination workbook (whether this is an existing workbook or a newly created file) within the same EXCEL.exe instance, then the Paste Special options appear as expected?
BFN,
fp.
Also, please can you confirm that if you open the source workbook & the destination workbook (whether this is an existing workbook or a newly created file) within the same EXCEL.exe instance, then the Paste Special options appear as expected?
BFN,
fp.
ASKER
@gerard_thusa
No COM add-ins installed. List is empty.
@fanpages
If I copy accross the sheets in the same excel instance then paste special appears as expected.
No COM add-ins installed. List is empty.
@fanpages
If I copy accross the sheets in the same excel instance then paste special appears as expected.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@fanpages
If I copy accross the sheets in the same excel instance then paste special appears as expected.
Yes, that is why I was asking. If that was not the case, then there was a more serious issue with your MS-Excel installation. I just wanted to make sure of this before posting...
The "Paste Special" functionality is only intended to be possible between workbooks within the same EXCEL.exe instance.
This is "by design" functionality.
ASKER
This is the answer
Yes, I know... that is why I asked the question I did.
Thank you for your confirmation in any respect.
Thank you for your confirmation in any respect.
Other people reported a conflict with Chrome browser. Closing the browser (or using a different one) fixed the problem.