3 Replies Latest reply: Jul 4, 2016 7:47 AM by Nilanjan Pradhan RSS

    Hide Excel Sheets-NPrinting

    Sankar Rajamoorthy

      hi experts..

             i have an excel report and it had 7 worksheet like sheet1,sheet2... i sent this report to three users with session access. user1 can see the first three worksheet , user 2 can see sheet 7 and sheet 6 , and the user 3 can see sheet 5,6,7.

        my problem is when user 1 receive and open the report first three sheet he can see with value and the other sheets shows data disabled

      because of the session access but i need fully hide those sheet which is have session access it ll not shows data disabled that ful sheets need hide like below

      Capture4.PNG

      how can i do this??