Page 1 of 2 1 2 >
Topic Options
#57383 - 05/02/18 09:52 AM Excel Direct Button not working
Dwaine_Went Offline
Adagio Fan

Registered: 04/02/10
Posts: 36
Loc: Barbados
I am having a problem where Excel Direct does not work on a new PC (Window 10 PC Version 1709 OS Build 16299.371 | Excel 2016 ).

Modules - Payables 9.3A 171027 , Receivables 9.2A 170726 , Sales Analysis 9.2A 170904 , Ledger 9.3A 171102 , Order Entry 9.2A 170710.

When the button is press on each occurrence nothing happens.


Any idea what's going on here?

Top
#57384 - 05/02/18 09:55 AM Re: Excel Direct Button not working [Re: Dwaine_Went]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
Hi Dwaine,

What is the version of MS Office on the new PC? There is a known issue with pre-installed versions of MS Office Home and Business that causes this problem.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#57385 - 05/02/18 09:59 AM Re: Excel Direct Button not working [Re: Dan_Desautels]
Dwaine_Went Offline
Adagio Fan

Registered: 04/02/10
Posts: 36
Loc: Barbados
The Office Version is Microsoft Office Professional 2016.

Top
#57386 - 05/02/18 10:16 AM Re: Excel Direct Button not working [Re: Dwaine_Went]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
If it came pre-installed your registry settings may not have been updated properly for Adagio to find Excel. Either way, you can refer to this document for help:

https://portal.softrak.com/resources/technicaltips/Working_with_ExcelDirect.pdf
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#57387 - 05/02/18 11:15 AM Re: Excel Direct Button not working [Re: Dan_Desautels]
Dwaine_Went Offline
Adagio Fan

Registered: 04/02/10
Posts: 36
Loc: Barbados
The document is very helpful but there is no LocalServer32 folder in the registry as outlined or even the InprocServer32 folder.

I have checked the old Adagio systems and those entries are there.

Top
#57388 - 05/02/18 11:39 AM Re: Excel Direct Button not working [Re: Dwaine_Went]
Warren Karges Offline


Registered: 08/04/11
Posts: 461
Loc: Waterloo, Ontario
I hope Softrak is going to look at alternate ways of addressing this, rather than asking everyone under the sun to re-install office, which is what will eventually be suggested here. This is becoming a common problem.
_________________________
Warren
Stief Group

Top
#57389 - 05/02/18 11:47 AM Re: Excel Direct Button not working [Re: Warren Karges]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
I have Office Professional 2016 on my machine and it works. However, I installed the full version from the download. If yours was upgraded from an older version or pre-installed with the computer, it may need to be reinstalled as Warren has indicated. It may be the quickest solution.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#57390 - 05/02/18 02:08 PM Re: Excel Direct Button not working [Re: Dan_Desautels]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
A complete install of Office/Excel updates the registry with the expected entries. The "pre installed" version of Office ( Professional or Home & Office) does not. A support ticket was opened with Microsoft Development and they have come back with a this question.
"Has Excel been ACTIVATED on the stations in question"

I presume the answer is "Yes" but please confirm.



Edited by Michael Mulrooney (05/02/18 02:13 PM)
Edit Reason: First resonse from Microsoft

Top
#57392 - 05/02/18 03:14 PM Re: Excel Direct Button not working [Re: Michael Mulrooney]
BAMPH Offline
Paradise is perspective

Registered: 07/15/01
Posts: 875
Loc: Christ Church, BARBADOS
Michael I can't speak for the others but the answer in my case is yes. Like you I would suspect that the answer in all cases is yes as from what I remember, one can't really use a properly licensed version of the product unless activated.

Pete
_________________________
Peter Banfield
BAMPH Consulting Services
Barbados

Top
#57398 - 05/03/18 05:24 AM Re: Excel Direct Button not working [Re: BAMPH]
Dwaine_Went Offline
Adagio Fan

Registered: 04/02/10
Posts: 36
Loc: Barbados
RESOLVED !

A repair of the office Application fixed the issue and the missing registry entries were found afterwards.

Cheers

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
1 registered (Softrak Support), 72 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14461 Topics
70641 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
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