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?
LVL 8
teomcamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtMechanical EngineerCommented:
About a year ago, there was a spate of complaints about this problem caused by Skype "Click to Connect" update. Uninstalling that update fixed the problem.

Other people reported a conflict with Chrome browser. Closing the browser (or using a different one) fixed the problem.
0
teomcamAuthor Commented:
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.
0
gerard_thusaCommented:
Hi,

Check your COM Add-Ins in Excel, can you list what you have there.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

[ fanpages ]IT Services ConsultantCommented:
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.
0
teomcamAuthor Commented:
@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.
0
teomcamAuthor Commented:
I just found the correct answer from technet as follow.
You can only use the Excel-specific paste special options such as Paste Formulas if you copy and paste within the same instance of Excel. If you copy and paste from one instance of Excel to the other, it's as if you copy from an entirely different application, so the Excel-specific options aren't available.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
[ fanpages ]IT Services ConsultantCommented:
@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.
0
teomcamAuthor Commented:
This is the answer
0
[ fanpages ]IT Services ConsultantCommented:
Yes, I know... that is why I asked the question I did.

Thank you for your confirmation in any respect.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.