Solved Problem opening Excell document from shortcut

Microsoft / Windows 7 enterprise sp1(...
January 24, 2019 at 08:54:28
Specs: Windows 7, 4096 D MMb
I store all my documents on the C drive under a filename My Files. Problem recently started.It is with regard to Excell 2010. I can open the file from the C drive but when I create a shortcut on the desktop and you try opening it via the shortcut, you get the following message: There is a problem sending the command to the program. In addition, a blank page appears. Any suggestions please.

When was the last time you did something for the first time?

message edited by Dawie


See More: Problem opening Excell document from shortcut

Reply ↓  Report •

✔ Best Answer
January 25, 2019 at 07:16:37
Why wouldn't you just create a desktop shortcut to your "My Files" folder & be done with it? IMO, that would be preferable to having multiple individual file shortcuts. Less desktop clutter. Of course that means you would have to open the folder, then open the file. I realize to some people, double clicking twice is a burdensome chore.


#1
January 24, 2019 at 09:46:39
Try going to Excel OPTIONS, then under Advanced find General where you should uncheck: "Ignore other applications that use Dynamic Data Exchange (DDE)"

If it's not enabled, just enable it, click OK, close Excel, then re-open, go there and disable it, press OK and again restart Excel.


Reply ↓  Report •

#2
January 24, 2019 at 09:56:09
Hi. Where do I find Excellent Options?

When was the last time you did something for the first time?


Reply ↓  Report •

#3
January 24, 2019 at 12:53:24
Excel Options can be found on the File tab, upper left of the worksheet window.

Third item from the bottom on my Excel 2010 File tab. Once in the Options menu, click Advanced and then scroll down to the General section.

Please let us know if Mrrrr's suggestion solves your issue.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Related Solutions

#4
January 24, 2019 at 23:28:06
Best solution would be repairing the Microsoft Office programs. Simply follow the instructions below:
open a Control Panel.in open control panel select the Programs, then click Uninstall Programs.after Scroll down until you find Microsoft Office.Click it, then choose Change from the shortcut menu.Click Online Repair, then select Repair.Change your installation of Microsoft Office to fix your Excel issues.Once the process is complete, restart your computer.

Reply ↓  Report •

#5
January 25, 2019 at 00:13:08
Hi M and D. I went through the option of Mrrr but that didn't work. Mark that also didn't work as well. What did work was a simple copy and paste exercise. Although it renders results I would still like to get to the bottom of the problem, i.e why cant it be "send" to the desktop or a shortcut "created" on the desktop. Anhy further ideas please. Is that extension .xlsx correct?

When was the last time you did something for the first time?


Reply ↓  Report •

#6
January 25, 2019 at 00:33:15
The extension xlsx is correct, yes.

Since you are asking this, do you have perhaps 2 office versions installed? An older one too maybe? Or maybe you uninstalled an older version to install 2010?

If that is the case, you could try re-associating which office program should open the xlsx file (not the shortcut directly). So right click the xlsx file, choose Open With, click on Browse, navigate to C:\Program Files\Microsoft Office\Office14, locate and select Excel.exe, click on Open, then make sure "Always use the selected program to open this kind of file" is SELECTED and click OK.


Reply ↓  Report •

#7
January 25, 2019 at 00:46:47
Thanks Mrrrr. Will try and come back.

When was the last time you did something for the first time?


Reply ↓  Report •

#8
January 25, 2019 at 01:30:09
Mrrrr I followed your instructions up to Office 14 but clicking that does not show Excel.exe. Btw my cut and paste didn't last long either.

When was the last time you did something for the first time?


Reply ↓  Report •

#9
January 25, 2019 at 01:35:13
Remember, I can open any Excel file. It's when I send it to the desktop or create a shortcut that the problem occurs.

When was the last time you did something for the first time?


Reply ↓  Report •

#10
January 25, 2019 at 03:03:27
There are various solutions given here:
https://windowsreport.com/there-was...

Please let me know if one of them works.


Reply ↓  Report •

#11
January 25, 2019 at 03:50:01
So far no luck with anyone.

When was the last time you did something for the first time?


Reply ↓  Report •

#12
January 25, 2019 at 07:16:37
✔ Best Answer
Why wouldn't you just create a desktop shortcut to your "My Files" folder & be done with it? IMO, that would be preferable to having multiple individual file shortcuts. Less desktop clutter. Of course that means you would have to open the folder, then open the file. I realize to some people, double clicking twice is a burdensome chore.

Reply ↓  Report •

#13
January 25, 2019 at 07:41:02
Hi riider. I've had My Files shortcut opened on my desktop for years and that is where I'm working from. You're probably right and it can be done. I just find the individual shortcuts easier to access a particular file and remember I have for example, 12 years' "Budgets" in this folder. Secondly, now I know there's a problem and I want to fix it. Remember, I have not experienced this before so I just feel I need to fix it. Surely you know what I mean.

When was the last time you did something for the first time?


Reply ↓  Report •

#14
January 25, 2019 at 07:43:52
riider:

A workaround is fine but it doesn't answer the bottom line question: Why doesn't it work as it should?

As Dawie said earlier: "Although it renders results I would still like to get to the bottom of the problem"

IOW: Curious minds want to know. ;-)


message edited by DerbyDad03


Reply ↓  Report •

#15
January 25, 2019 at 08:05:40
DerbyDad03, you hit it right on top. Incidentally, I have also installed Office 2000 to see if that could solve the issue. Same result. So the issue doesn't sit in Office(I think) but somewhere else.

When was the last time you did something for the first time?


Reply ↓  Report •

#16
January 25, 2019 at 08:48:50
When you open your Excel files, are they full screen? I found the following on another site, edited the wording a bit to make it more clear:

" What FINALLY fixed the issue was opening a workbook, then clicking on Full Screen. This resulted in a message saying Excel stopped working and will restart itself. After Excel restarted, the issue was miraculously resolved!!!!!"

I'm going to assume you restarted your system & that made no difference. What about scanning for viruses & malware? And running CCleaner-Slim & Bleachbit to clear out useless garbage that may be mucking things up? Be sure to restart after the cleaning.

https://www.ccleaner.com/ccleaner/b...
https://www.bleachbit.org/download


Reply ↓  Report •

#17
January 25, 2019 at 09:07:34
Hmm, so if it's not Office related, there are a few different approaches:
https://helpdeskgeek.com/how-to/fix...

Also I read something elsewhere - that you should check if the data in the following 3 registry keys is the same as on a working machine. Even though I have Office 2013, you can check if the 3 keys exist and they have same / similar data:

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsx\OpenWithProgids]
"Excel.Sheet.12"=hex(0):

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.xlsx\OpenWithList]
"a"="EXCEL.EXE"
"MRUList"="acb"
"b"="firefox.exe"
"c"="PDFXCview.exe"

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\DDECache\Excel\system]
"ProcessName"="EXCEL.EXE"
"WindowName"="Microsoft Excel"
"WindowClassName"="XLMAIN"

For second one it shouldn't be necessary to have b and c the same as mine, but a is of course important, and the MRU list should of course start with a.


Reply ↓  Report •

#18
January 25, 2019 at 11:07:50
When opening Excel files they go full screen. I've restarted and used AVG, Malwarebytes, Superantispyware, etc. to no avail. Have not tried CCleaner. Will do so. Mrrrr your suggestion is above my knowledge base.

When was the last time you did something for the first time?


Reply ↓  Report •

#19
January 25, 2019 at 11:30:09
Superantispyware is generally not recommended by forum helpers anymore. I haven't seen it mentioned in a long time. There are better programs such as Adwcleaner & Malwarebytes.
https://www.malwarebytes.com/adwcle...

And there are better AV programs than AVG. How long have you had it? I saw it mentioned on another site as causing problems with MS Office; uninstalling it fixed the problem.

CCleaner is a program you should install & run regularly. It's recommended in these forums all the time. I run it several times a day, both at home & at work. Use it to manage your startup apps as well. If you've never used it (or any other cleaner), you'll be amazed at how much useless garbage it finds. If you're concerned, try clicking the "Analyze" button before actually running the cleaner. Nothing will be removed but a list will be generated. Don't be surprised if it takes several minutes the 1st time you run it.

https://www.ccleaner.com/docs/cclea...


Reply ↓  Report •

#20
January 25, 2019 at 12:59:11
Thanks Riider. I hear what you say. I've had AVG for 10 years. Don't know what to say. Maybe I should delete some of the antispyware progs.

When was the last time you did something for the first time?


Reply ↓  Report •

#21
January 25, 2019 at 15:49:50
I've seen this problem several times and the suggestion in Response #1 has always fixed the issue for me.

From what you posted in your original question, you're storing the files in a folder named C:\My Files. If that's correct, I hope you're running frequent backups to another location. (CD/DVD/Thumb drive/external HDD, etc.)

Doing the best I can here... And remember, there's always more than one path to success. :)


Reply ↓  Report •

#22
January 25, 2019 at 22:57:00
Hi Jennifer. Yes I do have them on 3 different storage facilities. Just tell me, does the so-called "Administrator" plays a role here? Is it possible to have it fixed without having to go through this irritating "person"?

When was the last time you did something for the first time?


Reply ↓  Report •

#23
January 26, 2019 at 01:27:36
Jennifer, I tried response #1 but it didn't work. I think my problem is seated in the fact that my Win 7 program was and still is part of a domain that goes back 10 years. Although the pc has been written off, the software had not been removed and I was given this pc by my daughter. So all win 7 software are obsolete and inaccessible. That's my opinion.

When was the last time you did something for the first time?


Reply ↓  Report •

#24
January 26, 2019 at 03:03:20
But do you have the same issue with other software as well?
Or is it just shortcuts on Office documents, specifically Excel?

You said registry is too advanced, but you could try this:
1. Start - Run - type regedit (hit enter)
2. Pretty self-explanatory tree-like keys. So navigate to HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\ddeexec
3. Go to File - Export and choose a name and location (best to always backup when working with the registry)
4. Now right click the ddeexec key and select Delete, like this:
https://i.imgur.com/BfUxQDL.png
5. Close registry editor, restart PC, let us know if the problem is still there.

message edited by Mrrrr


Reply ↓  Report •

#25
January 26, 2019 at 03:42:31
Mrrrr yes it's Excel only as far as I can see. Eish! Will try and let you know.

When was the last time you did something for the first time?


Reply ↓  Report •

#26
January 26, 2019 at 04:06:39
Mrrrr I got to ddeexec but then you say Go To File-export and choose a name. I don't see "File".When I open ddeexec i see two options application and topic. That's all.

When was the last time you did something for the first time?


Reply ↓  Report •

#27
January 26, 2019 at 05:09:23
Here's how mine looks like (animated gif) - did all after ddeexec found, except didn't delete:
https://i.imgur.com/Hq3cfwi.gif

Are you saying that File menu doesn't offer the Export option in your case?


Reply ↓  Report •

#28
January 26, 2019 at 06:58:13
Mrrrr. I did it but when I click Delete it brings up message. Error while deleting key.

When was the last time you did something for the first time?


Reply ↓  Report •

#29
January 26, 2019 at 06:59:39
I followed your example point for point.

When was the last time you did something for the first time?


Reply ↓  Report •

#30
January 26, 2019 at 11:04:26
That means you don't have admin rights.

Reply ↓  Report •

#31
January 27, 2019 at 05:09:50
I know. How can I fix it without a password.

When was the last time you did something for the first time?


Reply ↓  Report •

#32
January 27, 2019 at 18:29:37
Dawie,

Did you mark Response #12 as the Best Answer?


message edited by DerbyDad03


Reply ↓  Report •

#33
January 29, 2019 at 00:10:01
Hi DD. Thanks for asking. You know I truly hate this part of Computing.net. Why would they want to put me in this position? I feel terrible every time I have to choose a "Best Answer". ALL are good answers and I have been dealing with some of these guys for years. They are like family to me. So yeah, I cannot tell you from the bottom of my heart why I chose Riider. I think he is the only one that give it to me straight. He takes no prisoners when he looks at a post and he thinks it's %#@&@!! Get my drift? Well that's why.

When was the last time you did something for the first time?


Reply ↓  Report •

#34
January 29, 2019 at 06:59:25
Thanks. I only asked because while riider's suggestion is a workaround that gets you where you need to be (a file that opens without any errors) it seems like you still haven't eliminated the root cause of your issue, which I believe was your ultimate goal.

I just wanted to make sure that it was you, as the OP, that chose the Best Answer and that nothing strange was going on. It's all good, I'm just keeping an eye on things, as any responsible moderator should be doing. ;-)

message edited by DerbyDad03


Reply ↓  Report •

#35
January 29, 2019 at 12:12:23
Thanks DB. Highly appreciated. You're correct. My problem has not been resolved at all, but I'm following Riider's advice now, for now.

When was the last time you did something for the first time?


Reply ↓  Report •

Ask Question