Solved

Cannot open embedded objects in excel

Posted on 2011-03-24
37
1,082 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 42

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 42

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 42

Expert Comment

by:dlmille
ID: 35270562
Understood...

Ok

dave
0
 
LVL 42

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 42

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 42

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
 
LVL 42

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 42

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 42

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 42

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 42

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Array problem 6 49
Pull Name and Phone out of Cell 2 14
How to always round a decimal up 5 20
WORKDAY formula question 4 9
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

756 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