Change Analysis excel workbook from 1.3 to 1.4

[Former Member]

Hello gurus,

I have an issue in Analysis of excel(AOE), We created many queries in AOE 1.3 and the file type when we save was by default microsoft excel                (which means that when we execute them from the launchpad, we open excel but without the analysis addin and thus the workbook is not displayed).

But in AOE 1.4 we have an option to save the the workbook as type ‘analysis workbook’ and thus when you execute it from the launchpad, it opens excel but with the addin and thus the workbooks is displayed.

Now we need to convert all the workbooks created in AOE1.3(type 'microsoft excel') to AOE1.4( type analysis workbook), please let me know if there is a way to change the type of workbook without opening one by one and saving it back with type analysis workbook.

Type of AOE WB is given below

Regards,

Bala

[david_stocker · Accepted solution]

Hi Gill,

We don't have a migration tool, so you'll have to migrate the workbooks manually by saving them in the new format.   

Whether it is worth the effort the set the registry key for the startup state so that AO always starts with Excel really depends on the situation and number of PCs.

Cheers,

Dave

[gleo_SRAM]

Hi Balaji,

Is it worth adding Analysis as an add in to Excel so once Excel starts the Analysis will be launched too?

I know you would have to do this on each client PC if that was a runner.

With regards,

Gill