Skip to Content
Former Member
Jan 25, 2016 at 10:15 AM

Migrate / Convert BEX Workbook to Analysis for Excel (2.1SP3)


We are planning to switch from uysing BEx Analyzer to Analysis for Office. We are however struggling with migrating existing BEx workbooks to the
Analysis for Office format.

I've tried numerous things:
* Tried on different PC's
* Tried on 2.1SP & 2.1SP3
* Tried with workbook in favorites & in roles
* Tried with different workbooks, all pretty simple, even with fresh created ones just for testing this
* Tried with numerous different settings in the Analysis for Excel conversion settings

We have not yet achieved migrating 1 single workbook in all of the abovetests! In which ever way we do it, we can select the source workbook but it
never generates a new workbook (sometimes the excel just hangs for eternity end the only solution is killing the session via the windows task manager, other times it stops pretty quick with a very generic error "Object reference not set to an instance of an object"....).

I logged a support-message for this, but i just wanted to hear if others have had the same experience (and maybe have some pointers towards a solution) or even if they have had no issues with this functionality and migrated their workbooks without a problem?