Skip to Content
Former Member
Sep 27, 2013 at 12:01 PM

Change Analysis excel workbook from 1.3 to 1.4


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




AOE.png (12.9 kB)