#44430 - 02/04/15 12:36 PM
Excel Direct button stopped working
|
Adagio Maestro
Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
|
I have not seen this before.
A client called and claimed that when he clicks on the Excel Direct button, nothing happens. Nothing bad, but nothing good. Just nothing!
I know that it has been working in the past, probably for many years.
They are running Excel 2010.
Any suggestions what might have caused this, and how to make it active again?
_________________________
Samuel Kopstick S Kopstick & Associates Inc Toronto, ON
|
Top
|
|
|
|
#45880 - 05/27/15 12:40 PM
Re: Excel Direct button stopped working
[Re: Softrak Support]
|
Stranger
Registered: 05/27/15
Posts: 1
Loc: NC
|
Hi, I'm having a similar issue, since having upgraded to Office 2013. I tried the link above, but get an access denied message. My issue is that from IC, when we click the excel Icon, nothing happens. On top of that, when we attempt to import items into IC, we get this pop-up. Now, when I try the same thing on another PC, which also has Office 2013, it works just fine. Out of 6 workstations, only one is having this issue. Thanks
|
Top
|
|
|
|
#46402 - 07/07/15 03:41 PM
Re: Excel Direct button stopped working
[Re: Martin]
|
Stranger
Registered: 07/20/10
Posts: 3
Loc: California
|
I am having the same issue. We upgraded from XP with Excel 2000 to Win 7 Pro with Excel 2010 last week and now when I try to click the Excel button, I am getting the error: Failed to connect to Excel.
The link above doesn't work, we are getting access denied. Any help would be useful, before the hordes of Excel loving users can't export their reports.
|
Top
|
|
|
|
#46404 - 07/07/15 04:31 PM
Re: Excel Direct button stopped working
[Re: Carl_Porter]
|
Adagio God
Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
|
|
Top
|
|
|
|
#46408 - 07/08/15 08:05 AM
Re: Excel Direct button stopped working
[Re: Carl_Porter]
|
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
|
Here is the information from the Link: I encountered this with another site this week (i.e. they upgraded, not installed new, from Office 20xx to 2013). What caused their ExcelDirect button to stop working was that their registry was not properly updated by that upgrade.
In short, what I would suggest people do to rectify this problem is to:
- determine the exact path that Excel is being run from
- make sure that rights is not the issue (open Adagio using Run as Administrator and determine if the problem still exists)
- if rights is not an issue, open the registry, collapse all trees and Edit | Find, excel.application
- you may have to F3 several times before you locate a LocalServer folder, which may be preceded by an InprocServer32 folder and/or followed by a LocalServer32 folder. There may also just be a LocalServer folder
- make sure the path in (Default) in the LocalServer folder and, if exists, the LocalServer32 folder is the 'correct' path to where the Excel.exe is located.
While using the [ComputerName]-CSVViewer= command is a solution to obtain an export, it produces an unformatted export. For someone not using Excel, this might be fine. However, for someone using Excel (most sites), I'm not convinced it would be satisfactory and editing the registry would be the better approach.
If you are not comfortable inspecting or editing the registry, you may want your Adagio Consultant to assist. We will add this information to the Technical Tip document in the coming weeks.
_________________________
Andrew Bates
|
Top
|
|
|
|
#46432 - 07/09/15 08:58 AM
Re: Excel Direct button stopped working
[Re: Softrak Support]
|
Stranger
Registered: 07/20/10
Posts: 3
Loc: California
|
The regedit solution worked for me, there was no Excel path in the default field.
Thanks
|
Top
|
|
|
|
#46437 - 07/09/15 11:29 AM
Re: Excel Direct button stopped working
[Re: Carl_Porter]
|
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
|
The revised Tech Tip has been posted in the Tech Tip section of the web site..
_________________________
Andrew Bates
|
Top
|
|
|
|
|
0 registered (),
95
Guests and
0
Spiders online. |
Key:
Admin,
Global Mod,
Mod
|
|
1865 Members
5 Forums
14465 Topics
70658 Posts
Max Online: 432 @ 01/20/25 10:17 PM
|
|
|
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
30
|
|
|
|
|
|