Skip to Content
author's profile photo Former Member
Former Member

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)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 27, 2013 at 03:17 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 27, 2013 at 02:32 PM

    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,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.