4 Replies Latest reply: Nov 2, 2017 5:53 AM by Ruggero Piccoli RSS

    Nprinting 17.2.3 How to create a XLSM

    John M�rtensson

      Hi,

       

      I've used a .xlsm template when creating the report, but I can't preview it as a xlsm (the option doesn't exist) and I'm not available to select this format as a task either.

       

      What should I do?

       

      I really want to use slicers in my file, but I think I need a .xlsm file for that to work properly. It cant use slicers in .xlsx previews or exports....

       

      /John

        • Re: Nprinting 17.2.3 How to create a XLSM
          Wouter Mak

          Hi,

          You can’t use the macro functionality in the nprinting designer or preview. But you can use a template with macro functionality.
          You can distribute your Excel with full functionalities.

          Wouter

          • Re: Nprinting 17.2.3 How to create a XLSM
            Cristina Punga

            I'm dealing with this same issue.

            I'm curious if anyone has any workaround.

            • Re: Nprinting 17.2.3 How to create a XLSM
              Ruggero Piccoli

              Hi,

               

              at the moment (stable version is September 2017) XLSM (and all other types of Office documents with macros) is not supported by Qlik NPrinting 17.*. For example you cannot set XLSM as output format of a generated report.

               

              Qlik NPrinting 16.* supports Office macros, so you can create a template in XLSM format and set XLSM as output format. Qlik NPrinting 16.* NEVER executes the VBA code of macros while creating the final reports for security reasons. Qlik NPrinting 16.* just copys the VBA code from the XLSM template to the XLSM generated report. When the user opens the report he can run the macros or you can associate them with the opening event.

               

              We don't know when when this gap between 16 and 17 will be filled.

               

               

              Best Regards,

              Ruggero

              ---------------------------------------------

              When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.