8 Replies Latest reply: Jul 5, 2016 8:33 AM by Grant Perkins RSS

    Does Monarch work with Office 2016?

    vanessalowther _

      Company has upgraded to Office 2016.

       

      Monarch pro v11 does not now work?

       

      Are there known problems with capatibility?

       

      Does any version of Monarch work with Office 2016?

       

      Business critical processes are now broken. Any advice appreciated!

        • Re: Does Monarch work with Office 2016?
          Olly Bond

          Hello Vanessa,

           

          Monarch v11 is from around 2010, and at that time Microsoft had released Office 2010 and enough information about Office 2013 so that Monarch v11 should cope with those versions. But Excel 2016 / Office 365 wasn't specced clearly in 2010, so it's perhaps unfair to ask the developers of that version of Monarch to have guessed how Microsoft intended to change Excelin the future.

           

          Monarch v13 does support Office 365. Do bear in mind that from Monarch 11.5 onwards, desktop automation is no longer available.

           

          Best wishes,

           

          Olly

          • Re: Does Monarch work with Office 2016?
            Grant Perkins

            Vanessa,

             

            Are there any specific things that don't work while other things are still OK?

             

            Microsoft sometimes drop support for quite old file formats  - it might just be a case of reviewing the changes made in office 2016 and comparing them to the outputs from Monarch and adjusting (either side) accordingly. It would be good to narrow things down to investigate.

             

            You might also try re-installing Monarch (on one machine if you are using individual licenses) to see if that then fixes the problem. Reinstalling would likely allow Monarch an opportunity to discover the Office 2016 changes. It may not help but it would be worth a try if the option is available to you.

             

            However the more complete solution would likely be to update Monarch and take advantage of the many new features compared to V11.

             

             

            Grant

            • Re: Does Monarch work with Office 2016?
              vanessalowther _

              Wow, just downloaded Monarch 13.

               

              It's so different from v11

               

              Guess you can't use templates from V11 on v13 - is this correct?

                • Re: Does Monarch work with Office 2016?
                  Chris Porthouse

                  That is not correct.  Your older models will still work with v13.  The way they are saved has changed.  Once you save a v11 model in v13, the extension is change to .dmod and becomes a binary file that is no longer readable/editable in a text editor such as notepad.  You CANNOT open v13 models in v11.

                  • Re: Does Monarch work with Office 2016?
                    Olly Bond

                    Hello Vanessa,

                     

                    Models in v11 in xmod format an be opened fine in Monarch v13, but you might want to use Monarch v13 in Classic mode and not in the Data Prep Studio mode.

                     

                    Best wishes

                     

                    Olly

                     

                    Olly Bond

                    MONARCH ? | ? | ? | ? EXPERTS

                    www.monarchexperts.com<http://www.monarchexperts.com>

                    olly@monarchexperts.com<mailto:olly@monarchexperts.com>

                    • Re: Does Monarch work with Office 2016?
                      Grant Perkins

                      Hi Vanessa,

                       

                      If you have downloaded the V13 trial you will have 2 user interface options.

                       

                      The "Classic" (formerly Monarch Pro level functionality) option is more like you are used to with V11, though still different. ("Standard Windows UI" look and feel changes introduced for all Windows application consistency over the years.  Love them or hate them they are new "Standards". For now!)

                       

                      The Data Prep UI is considerably different but encapsulates a lot of traditionally common "Classic" functionality in drag and drop actions.

                       

                      Compared to V11, V13 has many new features. A few things have been dropped along the way on the basis they were never (or extremely rarely) used by anyone. A handful of those things have crept back in to V13 where a genuine use case has re-established the need. Usually the re-introduction has been of an improved action.

                       

                      In general you should be able to make use of V11 .xmod and .xprj files directly in V13. However you can convert them all to DMOD and DPRJ which will put them in the new centrally controlled binary depository. If you edit and save an xmod or xprj file they will be saved as "d" versions not "x" versions. Thus the "d" versions are not backwards compatible (nothing new there) but nor are they directly editable files as the "x" versions were. This may not matter to you in any way but a few long time users were in the habit of making quick and simple changes to the older style files using text editors, sometimes for system admin purposes, and that is no longer possible.

                       

                      I would expect most V11 models to work but there may be a few changes and updates that are not entirely compatible if you are using some of the more complex (and obscure?) features. Or if an updated feature has more options that need to be considered and cannot be guessed by a "conversion" routine.

                       

                      The conversions can be applied in bulk if you wish using some of the functionality in the Monarch Utility. There is a section describing the process in the Monarch Learning Guide that should have installed when you loaded V13.

                       

                      HTH.

                       

                       

                      Grant