3 Replies Latest reply: Jun 22, 2018 6:34 PM by Stuart Cuthbertson RSS

    NPrinting  - Embed an Excel table in Powerpoint

    Paul ripley
    Paul ripley Dec 12, 2017 10:13 AM

      Hello

      We need to show zeros as ‘-‘ rather than ‘0’ in our tables in NPrinting when presented in Powerpoint

      I believe you can embed an excel table in Powerpoint so that you can then use excel functionalilty in powerpoint.

      I’m just wondering how to do this in NPrinting

       

      I can see you have the function InsertTable/Excel Spreadhseet

        Id like to take an existing excel s/sheet and insert it so that I can use the excel formatting to keep the formula a little more simple.  How do you do this?

      Many thanks

      Paul

       

       

       

        • Re: NPrinting  - Embed an Excel table in Powerpoint
          Stuart Cuthbertson
          Stuart Cuthbertson Jan 16, 2018 6:57 PM (in response to Paul ripley)

          Hi Paul,

           

          I think your question is really just a Microsoft PowerPoint question, not an NPrinting one. "How do I embed a pre-existing Excel spreadsheet file in a PowerPoint slide?"

           

          I don't believe it's possible to do that directly (in any PowerPoint file, nothing to do with NPrinting). However surely you can just embed a new Excel Spreadsheet using the button you've shown in your screenshot, and paste in the content from your pre-existing spreadsheet that exists separately?

           

          One word of warning: at the time of writing I am attempting to embed Excel spreadsheets in a Qlik NPrinting PowerPoint report (just as you want to do) and am finding that PowerPoint (the instance 'within' Nprinting) crashes consistently whilst doing this. (Nprinting Nov 2017 version.) A standalone instance of PowerPoint (outside NPrinting) doesn't crash following the same steps. I found your question whilst searching to see if I'm the only person experiencing this: whether it's me or a software bug. I'd be really grateful, if you try this out, if you can reply back if you also get crashes!

            • Re: NPrinting  - Embed an Excel table in Powerpoint
              Elias Lohilahti
              Elias Lohilahti Jun 21, 2018 4:52 AM (in response to Stuart Cuthbertson)

              Hi!

               

              Same problem here, Nprinting PP crashes every time trying to open Excel through that "Excel Spreadsheet" button! Does anyone know whether there is a fix or workaround for this? I would need to have an Excel Pivot table added to the PP presentation.

                • Re: NPrinting  - Embed an Excel table in Powerpoint
                  Stuart Cuthbertson
                  Stuart Cuthbertson Jun 22, 2018 6:34 PM (in response to Elias Lohilahti)

                  Good to know I'm not the only one. Do you still get this problem in the latest version of NPrinting? (April 2018 I believe, at time of writing.)

                   

                  I'm still on NPrinting Nov 2017 and unable to upgrade to April (or Feb) 2018 for other, unrelated reasons, so I haven't tested this against the latest version. Consequently I haven't reported this formally to Qlik as a possible bug. (In any case, I worked around it by just using regular PowerPoint tables and accepting a slight loss of functionality.)

                   

                  If you're still getting this problem with April 2018 release, I suggest it might be worth reporting to Qlik as a bug.