Solved

Cannot open embedded objects in excel

Posted on 2011-03-24
37
1,069 Views
Last Modified: 2012-05-11
Cannot open embedded objects in excel 2007.
When i open in excel /safe able to open the embedded object.

There is no response, as if the embedded object is not double clicked.
0
Comment
Question by:yagnesh_123
  • 17
  • 11
  • 4
  • +2
37 Comments
 

Author Comment

by:yagnesh_123
ID: 35205976
There is no response, as if the embedded object is not double clicked.
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35205998
Try clicking many times continuously. I have seen this happen.

Saqib
0
 

Author Comment

by:yagnesh_123
ID: 35239260
Tried clicking multiple times was not successfull :(

In excel Options Ignore other application option there is no tick mark.

Tried to register ole32.ddl but failed.

Return code was: 0x80070005
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35239279
Coming to think of it again, it was actually Autocad which contained the OLE object and we would continuously click on it until it opened.

what happens when you right-click on the object. Dont you get an option to open the object?

Saqib
0
 

Author Comment

by:yagnesh_123
ID: 35239309
No
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35239367
Looks like there is not much I can do about it.

Why don't you request attention from CS so that more experts are notified to look at your problem?
0
 

Author Comment

by:yagnesh_123
ID: 35242166
How to request attention from CS ?
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35266703
Please post sample.  I have some code, but rather than shooting it out, would rather test with something not working for you.

Can you do this with a non-confidential sample?

Dave
0
 

Author Comment

by:yagnesh_123
ID: 35269245
What you want as sample, since.....
I create a new excel file by opening excel file.
Embed a text file
Double click does not open.

Open Excel/safe mode
Embed a text file
Double click it opens.

Oplading Sample will make no difference.... Since nothing is in it.
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35269677
Now - that's not quite true.

I just embedded a text file and these operations work for me.

Does the attached work for you when you double click on it?

Dave
embed-Text-works.xlsx
0
 

Author Comment

by:yagnesh_123
ID: 35270526
Problem over here is for one particular user.

It should open in general scenario, i am able to open this file from my PC.
But that particular user cannot.
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35270562
Understood...

Ok

dave
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35275441
Try disabling any anti-virus software, then try to open the embedded object.  Several threads in the "cloud" seem to think that could be a related problem - especially when it can open in "safe" mode.

Dave
0
 

Author Comment

by:yagnesh_123
ID: 35276575
Can`t disable anti virus, its a corporate enviornment
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35276654
You might need to - to determine if this is the problem.  If its working fine on other machines and this is the problem then a reinstallation or reimage could be in order.  It might be worth an IT ticket.

You also might be able to temporarly disable - that option COULD be available.  IT have their ways, in the PUSH environment some software won't install/upgrade with anti-virus running so they've figured that out.

Dave
0
 

Author Comment

by:yagnesh_123
ID: 35276825
Full uninstallation & Reinstallation was already done earlier, before i raise this case.
Yet problem persist.
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35281772
of what?  The anti-virus software?  PS - when they uninstall do your test before they reinstall :)

Dave
0
 

Author Comment

by:yagnesh_123
ID: 35292276
Uninstallation & Reinstallation is done of MS Office Application.

Antivirus Software is as it is.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 41

Expert Comment

by:dlmille
ID: 35300273
Ok - suggest having IT uninstall and reinstall anti-virus.  And in the middle, you can do your test.  Or just have them admin in and take anti-virus offline (e.g., for 15 mins, or whatever) so you can test.

We have corporate policies as well - but if this is a conflict issue it is IT's responsibility to prove it is/is not and repair.

Dave
0
 

Author Comment

by:yagnesh_123
ID: 35304897
Antivirus is reinstalled, yet problem persist
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35304912
So, you tested it without antivirus and still the problem, correct?

Dave
0
 

Author Comment

by:yagnesh_123
ID: 35304953
Yes, uninstalled
Checked
Reinsttaled Antivirus
Problem is as it is

Is there anything i can uncheck in excel or disable, the features that are enabled when i open excel in normal mode.
Since in excel /safe it works
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35305700
Good question.  Let me investigate now that we have virus "resolved"...

Try this.  On that computer, add an embedded object.  Can you open it?  Save then open the file.  can you open it?

Dave
0
 

Author Comment

by:yagnesh_123
ID: 35305855
No.

I opened excel, new file--> embed a test  text file.

Double click cannot open.
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35306914
Is the test text file wholly embedded, or does it have links pointing anywhere?  That would exclude trust issues, I think, if its wholly embedded, no other links associated.  This is curious.

Dave
0
 

Author Comment

by:yagnesh_123
ID: 35308901
The test text file that is embedded is like

Create from file --> Display as icon
0
 
LVL 41

Expert Comment

by:dlmille
ID: 35309131
And you've probably scrubbed through all the security settings/trust settings already, yes?

I sent a note out to other E-E experts to see if they can provide new ideas.

Dave
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35309154
Yags, two quick questions and then we will skip the possibility of AV causing this.?

1) Are you using Norton AV?
2) If yes, then try this. Disable AV, Open fresh instance of Excel and re embed the text file. Does it open?

Sid
0
 

Author Comment

by:yagnesh_123
ID: 35309170
We are having Mcafee
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35309177
Kool then it is not an AV problem.

Next question.

Are you able to open the embedded object in a different pc?

Sid
0
 

Author Comment

by:yagnesh_123
ID: 35309198
Yes
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35309203
Ok next thing, Right click on the embedded file from the pc where it is giving you trouble and post the screen shot of the right click menu that pops up.

Sid
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35309206
Also if you could post a second screen shot of the entire Excel window from that pc.

Sid
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 35309659
Just another thought...can you create another user on the problem machine to see if the machine has the problem or just the user...and if this is a corporate account, maybe user can log in elsewhere to see if the problem is specific to the user (which I would doubt).

So basically, it would seem to me that the problem is the machine and not the user.  If IT re-built the whole machine, does the problem persist?  If so then it's something that IT is doing (possibly for/to the user).  If not, then it's a configuration for that user and maybe a rebuild is the way to go, although a lot of effort migrating all the pieces to the new machine.
0
 

Accepted Solution

by:
yagnesh_123 earned 0 total points
ID: 35312814
Add in was issue, now resolved
0
 

Author Closing Comment

by:yagnesh_123
ID: 35356733
Unchecked the Addins.
Now its working :)
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now