Analysis for Office and Bex Analyzer in same workbook compatiblity

[Former Member]

We have users moving off Bex Analyzer 3.5 to AFO 1.4.10

The users are opening their Bex Analyzer workbook in AFO

Inserting a new sheet with the new Bex 7.0 query

Then leaving the sheet with the old Bex 3.5 query.   They do not refresh the old queries.  Just leave in workbook for reference

Save the workbook and use in AFO

The question is:

Can this cause a problem?

I see in the links one of the following:

BexAnalyzer.xla
SAPBex.xla

The reason I think it might cause problems is because we have had occasions when a workbook looses it crosstab connections.

[former_member151004]

Hi Patty,

It shouldn't have any issue but you can also use the option "BiSharedAddinLauncher.exe /app XLS /CreateProcess" that start a new process if Microsoft Excel 2013 is already running.

Please check at the item "5.2.1 Configuring the Analysis Add-In Launcher" of the Admin guide.

Kind regards,
Diego Ferrary