Skip to Content
0

Analysis for office on Office 2016 64bit

Nov 18, 2016 at 10:12 PM

2k

avatar image

Dear,

I’m experiencing following issue with Analysis for office on Office 2016 64 bit on my new laptop.
First of all the version information:

Office:

Analysis for office (latest available version):

Sap GUI: 7.4

The error occurs when I try to insert a datasource:

I select ‘Select datasource’

In following screen: ‘Skip’

Than I get immediately following error without getting the option to select a connection:


I notice it is working when I perform the steps in following order:

Open Excel,

In analysis tab, select ‘Display’ so that the extra tab on the right opens.

Then I select ‘Select datasource’ & ‘Skip’ and then I get the list:

For files which have analysis sources in the file this is a serious issue, because these will crash immediately when opening. However when I first open an excel file with the analysis Display opened and than open the new excel file with analysis datasources included it seems to work.

So in my opinion something is not working related to the initialization of the analysis for office plugin as it seems not to correct start without opening this display part.

Thanks in advance

office-version.jpg (29.0 kB)
step3.jpg (31.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Tammy Powlas
Nov 19, 2016 at 10:34 AM
0

Hello -please see SAP Note https://launchpad.support.sap.com/#/notes/2267120/E

Resolution says the following per the note:

Resolution

  1. Enable Macro trust settings
  2. If you have other COM AddIn from Excel, that to disable it, to check if it is the root cause
Share
10 |10000 characters needed characters left characters exceeded
Arne Vanhoof Nov 19, 2016 at 10:03 PM
0

@Tammy,

Thanks I retrieved that note before posting the issue.
Macro trust settings have been enabled and no other com addin is active.

Issue remains the same.

Share
10 |10000 characters needed characters left characters exceeded
Arne Vanhoof Nov 21, 2016 at 06:31 AM
0

Dear,

Anyone any update on possible solutions? I tried complete repair of office but this didn't solve the issue also.

Thanks

Share
10 |10000 characters needed characters left characters exceeded
Arne Vanhoof Dec 09, 2016 at 08:36 AM
0

Also tried analysis for office 2.4, same error.

Solution that I provided myself:

remove office 64 bit
install office 32 bit

Install analysis for office 32 bit


Now everything is working, Analysis for office support for 64 bit seems to be not working..

Share
10 |10000 characters needed characters left characters exceeded