1 Reply Latest reply: May 15, 2014 10:15 AM by Olly Bond RSS

    Locking Cells in the Exported table

    Jean-Pierre Clermont

      Hi

       

      I would like to know if it is possible to lock certains colums in a Exported Excel file. We would like to do that for audit purposes.

       

      I have an other question: Can Monarch screen scrap or those Dtawatch a software that allows you to do that.

       

      Thank you

       

      JP

        • Locking Cells in the Exported table
          Olly Bond

          Hello Jean Pierre,

           

          Monarch will let you encrypt an XLSX file, but I don't think it will let you lock individual columns. You might find the Monarch Context plugin for Excel useful - this lets you include a locked version of the original report that is linked from the cells in the table sheet. Datawatch sales should be able to give you a web demo or let you try it.

           

          For screen scraping I'll defer to Grant - he's got previous in this area.

           

          Best wishes,

           

          Olly